Curriculum
- 1 Section
- 13 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Topics13
- 1.1Introducing Database-Resident Program Units About Database-Resident Programs Physical Storage & Execution Types Of Stored Program Units Stored Program Unit Advantages Modular Design Principles
- 1.2Creating Stored Procedures & Functions Stored Procedures & Functions CREATE Procedure / CREATE Function Creating Procedures & Functions RAISE_SALARY() Procedure SALARY_VALID() Function The Parameter Specification DEFAULT Clause SYSTEM & OBJECT Privileges Using The Development Tools
- 1.3Executing Stored Procedures & Functions Calling Procedures & Functions Unit Testing With EXECUTE ANONYMOUS BLOCK Unit Testing Specifying A Parameter Notation SQL Worksheet Unit Testing Calling Functions From SQL
- 1.4Maintaining Stored Program Units Recompiling Programs Mass Recompilation Using UTL_RECOMP() Dropping Procedures & Functions DROP Procedure / Function Data Dictionary Metadata Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES
- 1.5Managing Dependencies DEPENDENCY INTERNALS TRACKING DEPENDENCIES The DEPENDENCY TRACKING Utility SQL Developer Dependency Info Dependency Strategy Checklists
- 1.6Creating & Maintaining Packages About Packages Creating Packages Maintaining Packages Performance Considerations
- 1.7Advanced Package Capabilities Definer & Invoker Rights White Lists & Accessible By Persistent Global Objects Defining Initialization Logic Object Orientation Support
- 1.8Advanced Cursor Techniques USING CURSOR VARIABLES Using SYS_REFCURSOR Using CURSOR Expressions
- 1.9Using System-Supplied Packages DBMS_OUTPUT() UTL_FILE() FOPEN() Example
- 1.10Database Trigger Concepts About Database Triggers DML EVENT TRIGGER Sub-Types DATABASE TRIGGER Scenario TRIGGER Execution Mechanisms TRIGGERS Within SQL Worksheet
- 1.11Creating Database Triggers STATEMENT-LEVEL TRIGGERS Using RAISE_APPLICATION_ERROR() ROW-LEVEL TRIGGERS EXAMPLES OF TRIGGERS EMPLOYEE_SALARY_CHECK Example EMPLOYEE_JOURNAL Example BUDGET_EVENT Example INSTEAD OF TRIGGERS Triggers Within An Application
- 1.12Maintaining Database Triggers CALL Syntax Trigger Maintenance Tasks SHOW ERRORS Trigger DROP Trigger ALTER Trigger Multiple Triggers For A Table Handling Mutating Table Issues
- 1.13Implementing System Event Triggers What Are System Event Triggers? Defining The Scope Available System Events System Event Attributes
Maintaining Database Triggers CALL Syntax Trigger Maintenance Tasks SHOW ERRORS Trigger DROP Trigger ALTER Trigger Multiple Triggers For A Table Handling Mutating Table Issues
Prev