PL/SQL for Developers

Course Number:  575-JK
Recommended Duration:  2 days

Intended Audience
Application developers and designers who will use PL/SQL in their applications.

Course Overview
Provides skills and practice using PL/SQL to create procedures, functions, packages, triggers stored in the Oracle 11g and/or 10g database or used in development tools.  (Suitable for Oracle9i, Oracle8i, or earlier versions).  There are five machine exercises.

Objectives
Participants will learn to use PL/SQL to enhance the operations of their Oracle applications.  Several exercises will take students from the basics of PL/SQL through fairly extensive routines complete with looping, cursors, and error handling.  Oracle9i students will learn and practice using the new features of PL/SQL.

Prerequisites
Prior knowledge of Oracle fundamentals and basic SQL is necessary.  No previous experience with PL/SQL is required.

Topics

• Introduction to PL/SQL, syntax and fundamentals

• PL/SQL statements including Arithmetic, Looping, and Conditional Logic

• Error handling (Oracle-defined & user-defined)

• Using cursors

• PL/SQL Tables

• User Defined Records and Objects

• Procedures, Functions, and Packages

• PL/SQL Parameters

• Triggers

• Built-in Packaged Procedures

• Bulk bind

• New features of PL/SQL