Oracle 9i Introduction to PL/SQL

Request more details:

Description:
This course will introduction the Oracle 9i PL/SQL prgramming language. Students will control data sharing and locking, develop an understanding of multi-user and concurrent transactions and develop database triggers, stored procedures and functions.

View other Oracle Courses available
Prerequisites:
Oracle 9i Foundation: SQL Basics & SQL *Plus or equivalent experience.
PL/SQL Basics:
SQL and PL/SQL
PL/SQL anonymous block structure
PL/SQL Datatypes
Variable declarations
Object naming rules
Executable Statements
Repetition control
LOOP Statements - Basic LOOP, WHILE, FOR
CASE Expressions and Statements
Basic Coding Standards
SQL *PLUS development environment
Working with Database Data:
Selecting single and multiple rows
Referencing other variables or a database column`s datatypes
Modifying database data (DML)
Implicit cursor attributes
Transaction control commands
Autonomous Transactions
Selecting data into PL/SQL variables
Declaring explicit cursors
Referencing other structures datatypes
Using the cursor FOR LOOP
Displaying messages with DBMS_OUTPUT
FOR UPDATE / WHERE CURRENT OF
Exception Handling:
Writing an exception handler section
Handling predefined exceptions
Handling user-defined exceptions
Controlling exception processing
Using RAISE_APPLICATION_ERROR
Preventing PRAGMA EXCEPTION_INIT
Using SQLCOSE and SQLERRM
Stored PL/SQL Objects:
Introduction to procedures and functions stored in the database
Creating stored PL/SQL objects
Passing values with parameters
Formal vs. actual parameters
Parameter types - IN / OUT / IN OUT
Creating procedures, functions, packages, package bodies
Introduction to database triggers
Viewing and recompiling stored code