Course Topics

• Declaring PL/SQL Variables
• Writing SQL in PL/SQL
• Working with Composite Data Types
• Handling Exceptions
• Creating Procedures and Using Parameters
• Creating Packages
• Using Dynamic SQL
• Creating Compound, DDL, and Event Database Triggers
• Managing PL/SQL Code
• Writing Executable Statements
• Writing Control Structures
• Using Explicit Cursors
• Using PL/SQL Subprograms
• Creating Functions
• Working with Packages
• Design Considerations for PL/SQL Code
• Using the PL/SQL Compiler
• Managing Dependencies