Oracle Database Tutorials

PL/SQL Tutorials for Beginners

PL/SQL Tutorial list



PL/SQL Tutorial 11:- Intro Loops and Simple Loop Explained

In this tutorial you will leanr what are loops, Types of Loops In PL/SQL and Exit Statements with the Explanation of Simple Loop with Examples.


PL/SQL Tutorial 12:- While Loop In PL/SQL

In this tutorial you will leanr learn the concepts of While loop also learn how to handle Boolean Expression as test condition in While Loop.


PL/SQL Tutorial 13:- Numeric For Loop In PL/SQL

In this tutorial you will leanr learn the concepts of Numeric For loop With Multiple easy to understand Examples.


PL/SQL Tutorial 14:- Introduction of triggers in Oracle PL/SQL

A carefully drafted blog explaining all the concepts of triggers such as defination of triggers in database, Syntax,Uses, Types and Restriction of triggers in oracle database


PL/SQL Tutorial 15:- DML trigger With Examples in Oracle PL/SQL

Learn Concepts of Insert, Update and Delete Data Manipulation Language (DML) Triggers with Examples along with DML Triggers with IF-THEN-ELSIF Statement.


PL/SQL Tutorial 16:- Table Auditing Using DML Triggers in Oracle PL/SQL

Learn how to keep an eye on the user who is tempering the data of your table in this Table Auditing using DML Trigger tutorial.


PL/SQL Tutorial 17:- Synchronized Table backup Using DML Triggers in Oracle PL/SQL

Learn how to Create a Synchronized backup copy of a table using DML Trigger tutorial.


PL/SQL Tutorial 18:- Schema/user and Database Auditing Using DDL Triggers in Oracle PL/SQL

Learn how to create a DDL Trigger using Schema and Database auditing examples Trigger tutorial.


PL/SQL Tutorial 19: LogOn Database Event Trigger In Oracle PL/SQL

Learn how to write a Schema Level trigger to audit database LOGON event in Oracle PL/SQL.


PL/SQL Tutorial 20: LogOff Database Event Trigger In Oracle PL/SQL

Learn how to write a Schema Level and Database Level LogOff trigger to audit database LogOff event in Oracle PL/SQL.





  • Manish Sharma Oracle Rebellion Rider
  • Manish Sharma Oracle certified SQL expert
  • Manish Sharma oracle certified associate
  • Manish Sharma oracle certified professional
  • View Manish Sharma's profile on LinkedIn
  •          View Manish Sharma's profile on LinkedIn