1.     Overview of PL/SQL

·     What is PL/SQL?

·     Advantages

·     Architecture

·     PL/SQL vs SQL

2.     PL/SQL Control Statement

·     IF THEN

·     IF THEN ELSE

·     IF THEN ELSIF

·     Simple CASE

·     Searched CASE

LOOP Statements

·     Basic LOOP

·     EXIT

·     EXIT WHEN

·     CONTINUE

·     CONTINUE WHEN

·     FOR LOOP Statement

·     FOR LOOP Index

·     Lower Bound and Upper Bound

·     EXIT WHEN or CONTINUE WHEN Statement in FOR LOOP

·     WHILE LOOP

     Sequential Control Statements

·     GOTO Statement

·     NULL Statement