About this Course

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.

Audience Profile

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

Prerequisites

OR5450 Oracle SQL or equivalent experience.

Course Outline

• 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