Oracle PL / SQL

Duration:

3 Days

Pre-requisites:

Oracle 871 and Oracle 872 or a basic understanding of Relational DBMS, SQL, SQL * Plus, and ORACLE Data Dictionary.

Course Description

Students will learn to create procedures and functions using Oracle’s procedure language
extensions (PL/SQL) of SQL. Emphasis is put on debugging, using various Oracle tools.

Who Should Attend

This course is intended for Data processing professionals who require skills building Oracle Procedures using Oracle’s Procedure Language Extensions (PL/SQL).

Course Topics

PL/SQL Procedural Language

Conditional and Iterative Control

PL/SQL Records

PL/SQL Cursors

PL/SQL Exception Handling

PL/SQL Tables

PL/SQL Store Procedures & Functions

Scheduled Classes