Virtual Instructor-Led Training
3 Days (24 Hours)Oracle Database 12c Advanced PL/SQL explores advanced programming techniques and features in PL/SQL for Oracle Database 12c.
Course Objectives
- The PL/SQL Environment
- PL/SQL Program Structure
- Native Compilation
- Update, Insert, and Delete Statements
- Error Functions / Debugging
Upcoming Schedules
Certification
Certification
Course Prerequisites
Required
- Familiarity with programming languages
- Basic Knowledge of SQL, PL/SQL
Course Outline
Review of Introduction to PL/SQL
- Features and Benefits of PL/SQL
- Relationship of PL/SQL to SQL
- PL/SQL Development Tools
- Native Compilation
- PL/SQL System/Session Parameters
- PL/SQL Anonymous Block Variable Declarations
- PL/SQL Types and Records
- Declaring Variable Datatypes Dynamically
- Modifying Database Data (DML)
- Transaction Control Statements
- Declaring Explicit Cursors
- Implicit Cursor Attributes
- Exception Handling
- Creating Procedures, Functions, Packages, and DML Triggers
- Debugging with SQL Developer
- Conditional Compilation
- Warnings
Advanced Cursors
Advanced Packages
Advanced Triggers
PL/SQL Composite Datatypes and Collections
Bulk-Bind Data Loading Using PL/SQL
Using Oracle Supplied Packages
Writing Native Dynamic SQL
PL/SQL Wrapper
Understanding Dependencies
Large Object Management in PL/SQL
Objects
LABS