Objectives

During the development and/or control of programs for database processing, application programmers, developers and DBAs need more than the basic relational possibilities of Oracle SQL.

Therefore the objectives of this course are:

• to describe and exercise the procedural characteristics that are added by PL/SQL to SQL;
• to know the advantages of using stored procedures, functions and triggers.

Main topics

• Introduction PL/SQL:

'Stand Alone' versus 'Stored' procedures

• SQL support:

Writing SQL in a procedural environment

• Variables and constants:

Explicit declaration • implicit declaration

• Logical comparisons:

If-then-else structure

• Conditional and iterative control:

For-loop • do-while loop • loop-endloop • goto

• Cursor management:

Implicit and explicit cursors • attributes • cursor-for loop

• Error treatment:

Pre-defined exceptions • application exceptions

• Procedural objects:

packages • functions • procedures • triggers

• Oracle Supplied Packages