Oracle PL/SQL Introduction

Who should attend | Prerequisites | Content | Sample Notes | Next Class | Printer Friendly 

Class Summary

This class builds on the foundation of our Oracle SQL*Plus class, introducing delegates to Oracle's stored procedure language PL/SQL. Versions of this class can be organised for Oracle 8i and 9i.

The class consists of a mixture of lecture and hands on lab exercises.

Who Should Attend

This class is intended for analysts, junior developers, designers, beginning administrators and managers with SQL experience.

Prerequisites

A grounding in relational database concepts; familiarity with the use of graphical user interfaces. Attendance on our SQL*Plus class or equivalent experience is recommended.

Content

• PL/SQL Overview: Basic block structure, defining variables and constants; variable scope and lifetime; composite data types; records; PL/SQL tables; other sub-types.
  
  
• PL/SQL Conditional Processing; IF statements; FOR statements; WHILE loops.
  
  
• Executing SQL statements: using SELECT statements; implicit and explicit cursors; using INSERT, UPDATE and DELETE statements; handling execution errors.
  
  
• Exception handlers: overview; pre-defined exceptions; non pre-defined exceptions; user defined exception; nested block techniques.
  
  
• Stored Program Units: types; using procedures; functions; packages; triggers; 9i trigger features.
  

Sample notes

To be uploaded shortly ...

Suggested next class

Oracle Database Administration