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