Duration
Oracle Database 19c: PL/SQL Workshop
5 days
Overview
Oracle Database offers market-leading performance, scalability, reliability, and security, both on-premises and in the cloud. Oracle Database 19c is the current long term release, and it provides the highest level of release stability and longest time-frame for support and bug fixes.
Skills Covered
- PLSQL programming structure
- Using Explicit and Implicit Cursors in PLSQL
- For, while and basic Loop Processing in PLSQL
- Programmer Defined Procedures and Functions
- Using UTL_FILE and Directories for I/O
- Exception Handling
Introduction
- Introduction to PL/SQL
- 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
- Introducing Stored Procedures and Functions
- Creating Procedures
- Creating Functions
- Debugging Subprograms
- Creating Packages
- Working with Packages
- Using Oracle-Supplied Packages in Application Development
- Using Dynamic SQL
- Creating Triggers
- Creating Compound, DDL, and Event Database Triggers
- Design Considerations for the PL/SQL Code
- Tuning the PL/SQL Compiler
- Managing Dependencies
Programme scope, delivery arrangements and suitability are confirmed during enquiry.