Oracle Database 19c: PL/SQL Workshop

Course Overview

Course Outline

• Declaring PL/SQL Variables
• Writing Executable Statements
• Using SQL Statements Within a PL/SQL Block
• Writing Control Structures
• Working with Composite Data Types
• Using Explicit Cursors
• Handling Exceptions
• Creating Procedures and Functions
• Debugging Subprograms
• Creating and working with Packages
• Using Oracle-Supplied Packages in Application Development
• Using Dynamic SQL
• Creating Compound, DDL, and Event Database Triggers
• Design Considerations for the PL/SQL Code
• Tuning the PL/SQL Compiler
• Managing Dependencies
• Using SQL Developer and SQL*Plus
• Commonly Used SQL Commands
• REF Cursors
• Managing PL/SQL Code
• Implementing Triggers
• Using the DBMS_SCHEDULER and HTP Packages