Oracle PL/SQL

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 PL/SQL Stored Program Units course, this course is suitable for delegates intending to sit the Oracle examination #1Z0-147: Program with PL/SQL .

Note:

Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.

Topics Covered:

• Program Blocks
• Variables and Constants
• Data Types
• Using SQL Statements within PL/SQL Programs
• Generating SQL*Plus and SQL Developer 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

Requirements:

A working knowledge of Oracle's SQL*Plus or SQL Developer 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.