PL/SQL tutorial 1 Block Types in PL/SQL
PL-SQL tutorial 2 DIFFERENCES BETWEEN SQL AND PLSQL LANGUAGE
PL-SQL tutorial 3 Create a Basic PL/SQL Procedure for DML operation
PL-SQL tutorial 4 How to create a Basic PL_SQL Procedure
PL-SQL tutorial 5 How to create Basic PL/SQL Function in Oracle
PL-SQL tutorial 6 How to create Trigger to restrict user to perform DML
PL-SQL tutorial 7 How to create Trigger which fires after Startup on Database
PL-SQL tutorial 8 How to create a trigger which when the oracle database shutdown.
PL-SQL tutorial 9 How to create a trigger when a user logs on to an oracle database.
PL-SQL tutorial 10 How to create a trigger which fires when a user logs off an oracle database.
PL-SQL tutorial 11 How to use %rowtype data type in PLSQL
PL-SQL tutorial 12 – SUM OF DIGITS
PL-SQL tutorial 13 – TABLE OF ANY NUMBER
PL-SQL tutorial 14 – HOW TO USE FOR LOOP
PL-SQL tutorial 15 – FIBONACCI SERIES
PL-SQL tutorial 16 – How to calculate sum of sal column
PL-SQL tutorial 17 – how to declare variable via %type datatype and print values
PL-SQL tutorial 18 – How to use the Global variable in PL/SQL
PL-SQL tutorial 19 – Global variable in PLSQL
PL-SQL tutorial 20 – How to use Multiple global variable in plsql program
PL-SQL tutorial 21 – %rowtype datatype in plsql
PL-SQL tutorial 22 -Difference between %type and %rowtype datatype
PL-SQL tutorial 23 – How to perform DML via %type datatype in PLSQL
PL-SQL tutorial 24 – Selection Control Structure IF-ELSE
PL-SQL tutorial 25 – How to use Multiple IF-ELSIF-ELSE
PL-SQL tutorial 26 – Iterative Control Structure Simple loop
PL-SQL tutorial 27 – Iterative Control Structure WHILE LOOP
PL-SQL tutorial 28 – Iterative Control Structure FOR LOOP
PL-SQL tutorial 29 – GOTO statement in PL/SQL
PL-SQL tutorial 30 – What is cursor and why we need cursor in PLSQL ?
PL-SQL tutorial 31 – What is implicit cursor in PLSQL ?
PL-SQL tutorial 32 – What is explicit cursor in PLSQL ?
Thanks & Regards
Lalit Saini
Please leave a comment and subscribe to my YouTube Channel – Oracle World