WA1277 Introduction to Oracle9i: PL/SQL 1. Language Features Why Use Pl/Sql? Where Pl/Sql Program Units May Be Deployed The Java Alternative To Pl/Sql Structure Of A Pl/Sql Program Block Pl/Sql From Interactive Tools Generating Output 2. Declare clause Datatypes Declare Example Special Datatypes Type Variable Rowtype Record Type Table 3. Begin clause Data Manipulation Char And Varchar Numeric Date Boolean Comparison Operators Functions Date Calculations Selectinto Logic Control & Branching Goto Loop If-Then-Else Case 4. Exception Handling Exception Special Features System Defined Exceptions Using Sqlcode & Sqlerrm Implicit Cursors User-Defined Ex_Ined Pragma Exception_Init 5. Explicit cursors Understanding Cursors Explaining The Cursor Example Declare Cursor E Open Cursor Example Fetch Cursor Example Close Cursor Example Including Cursor Parameters Performing Updates From Cursors Using Forloop Cursors 6. Advanced Using Nested Blocks Using Declared Subprograms Display_Message() Procedure Example Get_Spouse_Name() Function Example