PL/SQL Programming

• Declaring variables
• Executable statements
• Global variables
• Substitution variables

•  Interacting with the Database Engine
• Using nested blocks

• SELECT INTO statement
• DML with PL/SQL blocks
• Using Implicit Cursors

• Using IF, CASE, LOOP, WHILE and FOR
• exit and continue
• Nested loops

• Using records
• %rowtype
• Table Of, Table Of Methods – NEXT, PRIOR, FIRST, LAST, Table of Records

• Single FETCH vs Multiple FETCH
• Looping through a Cursor
• %rowtype, %found
• Cursor For Loop
• Cursor with Parameters
• Bulk Collect

• Predefined exceptions
• Non predefined exceptions
• SQLCODE, SQLERRM
• User defined errors

• Procedures with IN parameter
• Using OUT parameters
• Using IN/OUT parameters
• Nesting procedures

• Using RETURN
• Error handling

• Creating Package SPEC
• Creating package BODY
• Overloading – Procedures and Functions
• Forward Declaration
• Oracle Supplied Packages

• BEFORE Triggers
• Using OLD/NEW
• Using AFTER triggers
• Using INSTEAD OF Triggers
• Autonomous transactions

Using PL/SQL Dynamic SQL

Handling database dependencies.