Oracle Database 19c: PL/SQL Workshop Virtual Classroom Live January 11, 2027

Course Overview

1: Course Overview Course Overview - Oracle Database 19c: PL/SQL Workshop

2: Introduction Practice 1-1: Getting Started

3: Introduction to PL/SQL

• Practice 2-1: Introduction to PL/SQL

4: Declaring PL/SQL Variables The %TYPE Attribute

• Practice 3-1: Declaring PL/SQL Variables

5: Writing Executable Statements

• Practice 4-1: Writing Executable Statements

6: Using SQL Statements Within a PL/SQL Block

• Practice 5-1: Using SQL Statements Within a PL/SQL

7: Writing Control Structures Basic Loop: Example

• Practice 6-1: Writing Control Structures

8: Working with Composite Data Types Associative Arrays (INDEX BY Tables)

• Practice 7-1: Working with Composite Data Types

9: Using Explicit Cursors Cursor FOR Loops

• Practice 8-1: Using Explicit Cursors
  Practice 8-2: Using Explicit Cursors: Optional

10: Handling Exceptions

• Practice 9-1: Handling Predefined Exceptions
  Practice 9-2: Handling Standard Oracle Server Exceptions

11: Introducing Stored Procedures and Functions

• Practice 10-1: Creating and Using Stored Procedures

12: Creating Procedures

• Practice 11-1: Creating and Using a New SQL Developer Database Connection
  Practice 11-2: Creating, Compiling, and Calling Procedures

13: Creating Functions

• Practice 12-1: Creating Functions

14: Debugging Subprograms

• Practice 13-1: Introduction to the SQL Developer Debugger

15: Creating Packages

• Practice 14-1: Creating and Using Packages

16: Working with Packages

• Practice 15-1: Working with Packages

17: Using Oracle-Supplied Packages in Application Development

• Practice 16-1: Using the UTL_FILE Package 1

8: Using Dynamic SQL

• Practice 17-1: Using Native Dynamic SQL

19: Creating Triggers

• Practice 18-1: Creating Statement and Row Triggers

20: Creating Compound, DDL, and Event Database Triggers

• Practice 19-1: Managing Data Integrity Rules and Mutating Table Exceptions

21: Design Considerations for the PL/SQL Code

• Practice 20-1: Using Bulk Binding and Autonomous Transactions

22: Tuning the PL/SQL Compiler

• Practice 21-1: Using the PL/SQL Compiler Parameters and Warnings

23: Managing Dependencies

• Practice 22-1: Managing Dependencies in Your Schema