Oracle PL / SQL
Duration
Three 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
