Oracle PL/SQL

This course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.

Together with the PL/SQL Stored Program Units course, this course is suitable for delegates intending to sit the Oracle PL/SQL Developer Certified Associate examination #1Z0-147: Program with PL/SQL.

Course Content

Program Blocks
Variables and Constants
Data Types
Using SQL Statements within PL/SQL Programs
Generating SQL*Plus and iSQLPlus Output
IF THEN ELSIF ELSE Statements
CASE Expressions
Basic Loops
The WHILE and FOR Loops
Nested and Labelled Loops
Using Cursors
Parameterised Cursors
Handling Named and UnNamed Exceptions
Generating User Defined Exceptions
Nested and Labelled Block Structures
Scope of Variables
PL/SQL Records
PL/SQL Tables of Records
Handling PL/SQL Tables

Skills

By the end of the course, the delegate will be able to write programs which use some or all of the primary PL/SQL programming constructs.

Prerequisites

A working knowledge of Oracle's SQL*Plus or iSQL*Plus products and practical experience in writing SQL statements. This can be gained by attendance on the Pre-Requisite course Oracle SQL. Some previous programming experience will also prove advantageous.

Before taking any exam, ensure you have the recommended experience.