PL/SQL course content

Anonymous Block

                Block structure

                Describing the Significance of Variables in PL/SQL

                Distinguishing Between PL/SQL and Non-PL/SQL Variables

                Declaring Variables and Constants

                Executing a PL/SQL Block

                %type & %rowtype attribute

Cursors in PL/SQL

                Cursor basics

                Using a cursor for a multi-row SQL query

Exception handling

    Using the when others clause

                Ensuring complete error checking

                Passing error messages to calling routine

                Boolean logic in PL/SQL

Condition and Looping statements

                Constructing an IF Statement

                Constructing and Identifying Different Loop Statements

                Controlling Block Flow Using Nested Loops and Labels

                Using Logic Tables

                If-then-else structure

Stored Procedure, Functions and Packages

                Basics of stored procedures

                Basics of functions

                Basics of packages

                Defining stored procedures & functions

                Function and stored procedures prototypes

                Passing arguments to functions and stored procedures

                Recompiling functions and stored procedures

                Pinning packages in the SGA with dbms_shared_pool.keep

                Package forward declaration

                Package dependency

                Package overloading

                Listing package information

Triggers

                Triggers and database events

                Defining a trigger

                Timing a trigger

                Enabling and disabling a trigger

Bulk collection

Advances Cursor