Oracle11g PL/SQL Programming

Summary:
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.

Duration:
3 Days/Lecture & Lab

Audience:
This course is designed for programmers and database administrators responsible for the development or maintenance of application systems which access an Oracle database.

Topics:

• 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

Prerequisites:
Students should have taken the Oracle11g SQL & SQL*Plus course and knowledge of a procedural language (e.g., COBOL, C) is required.