WA1475 Oracle Database 10g: Program With PL/SQL Part I Course Outline   1. LANGUAGE FEATURES UNDERSTANDING PL/SQL STRUCTURE OF A PL/SQL PROGRAM BLOCK PL/SQL FROM INTERACTIVE TOOLS GENERATING OUTPUT WITHIN SQL*PLUS 2. DECLARE CLAUSE ABOUT THE DECLARE CLAUSE DECLARE SIMPLE TYPES COMPLEX TYPES TYPE ... TABLE TYPE ... RECORD 3. BEGIN CLAUSE ABOUT THE BEGIN CLAUSE PERFORMING DATA MANIPULATION LOGIC CONTROL & BRANCHING IF-THEN-ELSE CASE 4. EXCEPTION CLAUSE ABOUT THE EXCEPTION CLAUSE ISOLATING THE SPECIFIC EXCEPTION PRAGMA EXCEPTION_INIT SQL%ROWCOUNT & SELECT...INTO 5. EXPLICIT CURSORS ABOUT EXPLICIT CURSORS ADVANCED CURSOR TECHNIQUES 6.ADVANCED PROGRAMMING: NESTED BLOCKS 7. ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS