---

You will receive a hands-on introduction to the Oracle10g PL/SQL procedural language for SQL. You will cover how to insert, update, and delete data; control data sharing and locking; debug and use error report procedures; and develop database triggers, stored procedures, and functions for future reuse.

Highlights

• The PL/SQL Environment and Program Structure
• Update, Insert and Delete Statements
• Error Report Functions
• Debugging Procedures
• Logical Comparisons
• To define, store and Execute Procedures
• To define, store and execute Functions
• To create Package Specifications and Package Bodies
• To create composite datatypes
• To work with implicit and explicit cursors

Course Outline

1. PL/SQL Basics

• SQL and PL/SQL
• PL/SQL anonymous block structure and Datatypes
• Variable declarations
• Object naming rules
• Executable Statements
• Operators in PL/SQL
• Repetition control
• LOOP statements - Basic LOOP, WHILE, FOR
• CASE Expressions and Statements
• Nested Blocks
• Labels and block identification
• Basic Coding Standards
• SQL*PLUS development environment

2. Working with Database Data

• SELECT statements in PL/SQL
• Selecting single and multiple rows
• Referencing other variables or a database column's datatypes
• Modifying database data (DML)
• Transaction control commands
• Selecting data into PL/SQL variables
• Explicit cursors
• Transaction control commandsReferencing other structures datatypes
• Using the cursor FOR LOOP
• FOR UPDATE / WHERE CURRENT OF

3. Exception Handling

• Writing an exception handler section
• Handling predefined and user-defined exceptions
• Controlling exception processing
• Preventing unhandled exceptions
• RAISE_APPLICATION_ERROR
• Using SQLCODE and SQLERRM

4. Stored Pl/Sql Objects

• Introduction to procedures and functions stored in the database
• Creating stored PL/SQL objects
• Passing values with parameters
• Creating procedures, functions, packages, package bodies
• Introduction to database triggers
• Viewing and recompiling stored code

Space is limited. Register today to save your space!