دوره Oracle PL/SQL 19c for Developers

?What is PL/SQL
Advantages of using PL/SQL
Basic Structure of a PL/SQL Block

Named blocks
Data Types
Declaration of variables
%TYPE Attribute
Syntax and rules
Data types in PL/SQL
Using variables in PL/SQL blocks
Control Structures

Using SQL Statements Within a PL/SQL Block
IF-THEN-ELSE
CASE statements
FOR loops
WHILE loops
Working With Composite Data Types

Syntax and examples
Input and output parameters
Creating and executing functions in PL/SQL
Usage in SQL statements

Explicit cursors
Implicit cursors
Fetching data
Cursor attributes
Exception Handling
Advanced Cursor Techniques (parameterized, FOR UPDATE, etc.)

Handling Predefined Exceptions
User-defined exceptions
Using TRY-CATCH blocks
Transaction Control

Using nested blocks and transactions
Managing nested transactions
Creating and using savepoints
Advanced Cursor Techniques

Usage scenarios

Introducing Database-Resident Program Units
Creating Stored Procedures & Functions
Executing Stored Procedures & Functions

Database Trigger Concepts
Creating triggers
Types of triggers
Using triggers for auditing
Maintaining Database Triggers

Using Native Dynamic SQL
Creating Compound , DDL and Event Database Triggers

Creation
Specification
Implementation
Execution
Invocation
Real-world application
Code walkthrough
Using System-Supplied Packages (DBMS_OUTPUT, UTL_FILE, DBMS_SQL)