ORALCE PL/SQL

This Oracle Database: PL/SQL Fundamentals training introduces you to PL/SQL and explains the benefits of this programming language. You’ll learn how to create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.

This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database.

Handle runtime errors, Describe stored procedures and functions, Use cursors to process rows, Design PL/SQL anonymous block that execute efficiently, Describe the features and syntax of PL/SQL, Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)

Demonstrations and hands-on exercises reinforce the fundamental concepts you’ll learn in this course, which is designed for a 12C and 19C audience.

Oracle Database 19c: PL/SQL Workshop

·        
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

Oracle Database Program with PL/SQL
Exam Number: 1Z0-149