CHOOSING A SQL & PL/SQL INTERFACE • USING SQL DEVELOPER • USING SQL*PLUS • USING APPLICATION EXPRESS • USING JDEVELOPER STUDIO


LANGUAGE FEATURES • UNDERSTANDING PL/SQL • STRUCTURE OF A PL/SQL PROGRAM BLOCK • USING PL/SQL FROM SQL*PLUS


DECLARE CLAUSE • ABOUT THE DECLARE CLAUSE • DECLARE SIMPLE TYPES • DECLARE COMPLEX TYPES • TYPE ... TABLE • TYPE ... RECORD


BEGIN CLAUSE • ABOUT THE BEGIN CLAUSE • PERFORMING DATA MANIPULATION • LOGIC CONTROL & BRANCHING • LOOP • IF-THEN-ELSE • CASE


EXCEPTION CLAUSE • ABOUT THE EXCEPTION CLAUSE • ISOLATING THE SPECIFIC EXCEPTION • PRAGMA EXCEPTION_INIT • SQL%ROWCOUNT & SELECT...INTO


EXPLICIT CURSORS • ABOUT EXPLICIT CURSORS • ADVANCED CURSOR TECHNIQUES


ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS