Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

Programming with Oracle PL/SQL – Introduction

2 day course

View Detailed Outline in PDF format

Get Adobe Reader

The Oracle PL/SQL language provides for programming logic features not contained within SQL. The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available. Topics to be covered include understanding the environment and context in which PL/SQL operates, declaring program variables and complex data types, developing logic within PL/SQL program blocks, fetching data from the database into program variables, returning program output to users, handling program exceptions, using explicit and implicit database cursors, and using the advanced features of nested blocks and subprograms.

Course Topics:

(for a full detailed outline, visit our PDF link above)

PL/SQL Language Features

  • Understanding PL/SQL
  • Structure of a PL/SQL program block
  • Using PL/SQL with interactive tools
  • Generating output within SQL*Plus

DECLARE Clause

  • About the DECLARE clause
  • DECLARE Clause Objects and Data Types
  • Declare simple types
  • Complex types
  • Type... Table  and Type... Record
  • Extended User-defined Types

BEGIN Clause

  • About the BEGIN clause
  • What Goes in the BEGIN Clause?
  • Performing data manipulation
  • Comparisons, logic control & branching
  • Regular Expressions
  • IF-THEN-ELSE
  • Types of Looping or iteration
  • CASE

EXCEPTION Handling

  • About the EXCEPTION clause
  • Types of exceptions
  • Isolating the specific exception
  • PRAGMA EXCEPTION_INIT
  • Error functions
  • Implicit cursors
  • SQL%ROWCOUNT & SELECT... INTO
  • User-defined events

Explicit Cursors

  • About Explicit Cursors
  • Advantages of explicit cursors
  • Advanced Cursor Techniques
  • Updatable cursors and cursor parameters
  • Using FOR… LOOP cursors

Programming with Nested Blocks

  • What is a nested block?
  • How to use a nested block
  • Global vs. Local Objects
  • Global vs. Local Exceptions

Declared Subprograms

  • What are subprograms?
  • Distinction with nested blocks
  • Distinction with stored program units
  • Procedures and Functions