Back to Search Results

Training Course Summary:

Delegates:

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.

Objectives:

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.
Together with the Oracle 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.

Together with the Oracle SQL*Plus course, this course is suitable for delegates intending to sit the Introduction to Oracle SQL and PL/SQL Examination #1Z0-001.

Pre-Requisites:

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. Some previous programming experience will also prove advantageous.

Training Course Overview/Content:

Topics Covered:

Program Blocks
Variables and Constants
Using SQL Statements within PL/SQL Programs
Generating SQL*Plus and iSQLPlus Output
IF Statements
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
PL/SQL Records
PL/SQL Tables of Records
Handling PL/SQL Tables

Requirements:







Follow-On Courses:

PL/SQL Stored Program Units

Reports

Forms 6i - Part I

Forms 9i - Part I

DBA Part I - Architecture & Administration