Curriculum
- 1 Section
- 9 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Topics9
- 1.1INTRODUCING DATABASE PROGRAM UNITS ABOUT database program units TYPES of pl/sql program units TYPES of stored program units ADVANTAGES of using stored program units
- 1.2CREATING STORED PROCEDURES & FUNCTIONS ABOUT stored procedures & functions CREATING procedures & functions EXECUTING procedures & functions
- 1.3MAINTAINING STORED PROCEDURES & FUNCTIONS RECOMPILING & dropping programs DATA dictionary storage MANAGING dependencies
- 1.4CREATING & MAINTAINING PACKAGES ABOUT packages CREATING packages ADVANCED programming techniques MAINTAINING packages
- 1.5ADVANCED CURSOR TECHNIQUES USING cursor variables USING cursor expressions
- 1.6USING SYSTEM-SUPPLIED PACKAGES DBMS_OUTPUT() UTL_FILE()
- 1.7RETAINING DATABASE TRIGGERS ABOUT database triggers STATEMENT-level triggers ROW-level triggers EXAMPLES of triggers INSTEAD of triggers EPMPLOYING triggers within an application
- 1.8MAINTAINING DATABASE TRIGGERS CALL syntax TRIGGER maintenance tasks SHOW errors trigger DROP trigger ALTER trigger HANDLING multiple triggers for a table HANDLING mutating table issues
- 1.9IMPLEMENTING SYSTEM EVENT TRIGGERS WHAT are system event triggers? DEFINING the scope AVALAIBLE system events SYSTEM attributes