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 SQL course, this course is suitable for delegates intending to sit the Oracle PL/SQL Developer Certified Associate examination #1Z0-001: Introduction to Oracle SQL and PL/SQL.
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.
|
Note: |
|
Before taking any exam, ensure you have the recommended experience.
|
Topics Covered: |
- 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
|
Requirements:
|
|
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.
|
