Oracle PL/SQL Foundation
Oracle's Procedural Language for SQL (PL/SQL) provides programming logic features not contained within standard SQL. In this 3 day course, the student will learn to use the PL/SQL language with its various structures and constructs and then continue on to look at using PL/SQL for writing stored procedures, functions, triggers and more. Security issues of PL/SQL will also be covered. This course is based on Oracle 11g PL/SQL.
This course is aimed at application developers and database administrators.
Attendees need to be comfortable working with SQL and should have some programming experience in another programming language
- PL/SQL Variables and Datatypes
- PL/SQL Syntax and Logic
- Stored Procedures and Functions
- Exception Handling
- Records, Collections and User Defined Types
- Bulk Operations
- Using Packages
- Creating Packages
- Working with LOBs
- Maintaining PL/SQL Code
- Dynamic SQL