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

Share with others

Can't Read? Click to Generate New Code

Enter the verification code shown above into the text box below