Oracle Database 19c: PL/SQL Workshop — Lesson 1: PL/SQL Blocks, Variables, Control Flow, and SQL Integration

Technical Scope

• anonymous blocks and scope
• variables, records, constants, and attributes
• conditions, loops, and nested blocks
• SELECT INTO, DML, transactions, and implicit cursors

Instructor Demonstration

Demonstrate anonymous blocks and scope inside an order-processing package with validation, reusable APIs, bulk operations, and database-side diagnostics, then capture the exact configuration, command, transaction, report, or code evidence that proves the result.

Applied Workshop

Implement a controlled workshop covering variables, records, constants, and attributes and conditions, loops, and nested blocks, then test a failure or exception involving SELECT INTO, DML, transactions, and implicit cursors.

1. Confirm environment, identity, data, dependencies, and expected result.
2. Complete the product-specific implementation or analysis.
3. Capture commands, configuration, output, logs, transactions, or reports.
4. Explain the operational, security, performance, or business trade-off.

Validation Standard

The PL/SQL Blocks, Variables, Control Flow, and SQL Integration result must be reproducible, traceable to approved inputs, and consistent with the expected Oracle product behavior.

• The intended target and ownership are verified.
• The result is supported by reproducible evidence.
• Security, performance, reliability, and support impact are reviewed.
• Unexpected behavior is investigated before acceptance.

Failure Analysis

Diagnose issues in anonymous blocks and scope, variables, records, constants, and attributes, conditions, loops, and nested blocks, or SELECT INTO, DML, transactions, and implicit cursors without making an unverified production change.

Learners isolate the smallest proven cause, apply a reversible correction, rerun validation, and record the preventive action.