Upon completion of this course, the student will be able to: Identify the features and components of Procedure Builder. Describe the features and components of the Object Navigator interface. Identify the Object Navigator objects. Describe the features and components of the PL/SQL Interpreter interface. Use the PL/SQL Interpreter interface to execute SQL statements. Debug a program unit in the PL/SQL Interpreter interface. Describe the features and components of the Program Unit Editor. Describe the features and components of the Stored Program Unit Editor. Describe the features and components of the Database Trigger Editor. Identify the types of subprograms. Debug a stored program unit.
Unit 1: Procedure Builder Fundamentals
- Introducing Procedure Builder Components
- Using the Object Navigator
- Managing the Object Navigator Objects
- Using the PL//SQL Interpreter
- Using the Program Unit Editor
- Using the Stored Program Unit Editor
- Using the Database Trigger Editor
Unit 2: Subprograms
- Introducing Subprograms
- Creating Stored Procedures
- Executing Procedures
- Creating Functions
- Executing Functions
- Creating Packages
Unit 3: Debugging Program Units
- Debugging Theories
- Setting Breakpoints
- Setting Debug Triggers
- Examining Local Variables
- Debugging Stored Program Units