LANGUAGE FEATURES
• UNDERSTANDING PL/SQL
• STRUCTURE OF A PL/SQL PROGRAM BLOCK
• PL/SQL FROM INTERACTIVE TOOLS
• GENERATING OUTPUT WITHIN SQL*PLUS
DECLARE CLAUSE
• ABOUT THE DECLARE CLAUSE
• DECLARE SIMPLE TYPES
• COMPLEX TYPES
• TYPE ... TABLE
• TYPE ... RECORD
BEGIN CLAUSE
• ABOUT THE BEGIN CLAUSE
• PERFORMING DATA MANIPULATION
• LOGIC CONTROL & BRANCHING
• 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: NESTED BLOCKS
ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS
Course Outline Part II
INTRODUCING DATABASE PROGRAM UNITS • ABOUT DATABASE PROGRAM UNITS • TYPES OF PL/SQL PROGRAM UNITS • TYPES OF STORED PROGRAM UNITS • ADVANTAGES OF USING STORED PROGRAM UNITS • DEVELOPMENT TOOLS
CREATING STORED PROCEDURES & FUNCTIONS • ABOUT STORED PROCEDURES & FUNCTIONS • CREATING PROCEDURES & FUNCTIONS • EXECUTING PROCEDURES & FUNCTIONS • HANDLING COMPILATION ERRORS
MAINTAINING STORED PROCEDURES & FUNCTIONS • RECOMPILING & DROPPING PROGRAMS • DATA DICTIONARY STORAGE • MANAGING DEPENDENCIES
CREATING & MAINTAINING PACKAGES • ABOUT PACKAGES • CREATING PACKAGES • ADVANCED PROGRAMMING TECHNIQUES • MAINTAINING PACKAGES
ADVANCED CURSOR TECHNIQUES • USING CURSOR VARIABLES • USING CURSOR EXPRESSIONS
USING SYSTEM-SUPPLIED PACKAGES • DBMS_OUTPUT() • UTL_FILE()
CREATING DATABASE TRIGGERS • ABOUT DATABASE TRIGGERS • STATEMENT-LEVEL TRIGGERS • ROW-LEVEL TRIGGERS • EXAMPLES OF TRIGGERS • INSTEAD OF TRIGGERS • EMPLOYING TRIGGERS WITHIN AN APPLICATION
MAINTAINING DATABASE TRIGGERS • CALL SYNTAX • MULTIPLE TRIGGERS PER EVENT • TRIGGER MAINTENANCE TASKS • SHOW ERRORS TRIGGER • DROP TRIGGER • ALTER TRIGGER • HANDLING MUTATING TABLE ISSUES
IMPLEMENTING SYSTEM EVENT TRIGGERS • WHAT ARE SYSTEM EVENT TRIGGERS? • DEFINING THE SCOPE • AVAILABLE SYSTEM EVENTS • SYSTEM EVENT ATTRIBUTES
