Oracle Database 10g: Program with PL/SQL - Level 1

Request more details:

Description:
The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered.

View other Oracle Courses available
Prerequisites:
Oracle Database 10g: Introduction To SQL Complete Library
LANGUAGE FEATURES:
Understanding PL/SQL
Structure of a PL/SQL Program Block
PL/SQL from Interactive Tools
Geberating Output within SQL *Plus
DECLARE CLAUSE:
About the Declare Clause
Declare Simple Types
Complex Types
Type ... Table
Type ... Record
BEGIN CLAUSE:
About the Begin Clause
Performing Data Manipulation
Logic Control & Branching
If-Then-Else
Case
EXCEPTION CLAUSE:
About the Exception Clause
Isolating the specific Exeption
Pragma Exception_INIT
SQL%Rowcount & Select ... INTO
EXPLICIT CURSORS:
About Explicit Cursors
Advanced Curser Techniques
ADVANCED PROGRAMMING: NESTED BLOCKS:
ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS: