The course provides a comprehensive introduction to PL/SQL, Oracle’s procedural language extension to SQL. PL/SQL is used to write stored procedures, packages, and database triggers. PL/SQL will be of particular interest to individuals developing applications in a client-server or multi-tier environment.

This course can be taught for any Oracle version.

Programmers and Database Administrators responsible for the development or maintenance of application systems which access an Oracle database.

• Overview of PL/SQL
• Variables and Constants
• PL/SQL Executable Statements
• Embedding SQL Within PL/SQL
• PL/SQL in the SQL*Plus Environment
• Handling Exceptions
• PL/SQL Built-in Functions
• Subprograms
• PL/SQL on the Server
• Using Predefined Packages

OR5450 Oracle SQL or equivalent experience.