PLSQL Queries

• Overview of PLSQL
• Declaring PLSQL Variables
• Writing executable statements
• Interacting with Oracle DB Server
• Writing Control structure
• Working with Composite Data Types
• Using explicit cursors
• Handling Exceptions
• Creating Procedure
• Creating Functions
• Working with Packages
• Using oracle-supplied Packages in Application Development
• Using Dynamic SQL
• Design consideration for PLSQL Code
• Triggers
• Creating Compound, DDL, and Event Database Triggers
• Using the PLSQL Compiler
• Managing PLSQL Code
• Managing Dependencies