Oracle 12c/18c/19c PLSQL

Uncategorized

About Course

SQL is combined with procedural features of programming languages to form PL/SQL. Along with SQL and Java, PL/SQL is one of three core programming languages embedded in the Oracle Database.

Course Content

ANONYMOUS PLSQL BLOCK

Variables
Data Types
Bind variables
PLSQL operators
Nested blocks
Implicit data conversion
SELECT INTO statement
Select Operations
DML Operations
DBMS_OUTPUT.PUT_LINE
Nested blocks and Variable scopes

CONTROL STRUCTURES

COMPOSITE DATA TYPES

CREATING FUNCTIONS

syntax of CREATE FUNCTIONS
Benefits of user defined functions
Executing user defined functions
Restrictions on functions calls
Creating functions
Nested function
Overloading Functions
Nesting Functions and Procedures
Functions in Select and DML Queries
Dropping functions

EXCEPTIONS AND EXCEPTION HANDLING

CREATING PROCEDURES

EXPLICIT CURSORS AND IMPLICIT CURSORS

TRIGGERS

Triggers – Create, Replace, Drop
Triggers Basics
Triggers Types
Database Triggers
DML Triggers Overview
Statement Triggers
Row Level Triggers
INSTEAD OF Triggers
Oracle Internal Tables for Trigger Management
Trigger Management
SECURITY Triggers

CREATING PACKAGES

PACKAGE FEATURES

ORACLE SUPPLIED PACKAGES

Student Ratings & Reviews

No Review Yet

No Review Yet