Oracle Database Tutorials

PL/SQL Tutorials for Beginners

PL/SQL Tutorial list



Actual Parameters vs Formal Parameters

In this blog you you will find the answer of a question which you must have faced during the Interview. Read What are actual and formal parameters in programming?


PL/SQL Tutorial 41:- How to Create PL/SQL Stored Procedure without Parameter

Learn How to Create PL/SQL Stored Procedure without Parameter in Oracle Database by Manish Sharma


PL/SQL Tutorial 42:- How to Create PL/SQL Stored Procedure with Parameter

Learn How to Create PL/SQL Stored Procedure with Parameter in Oracle Database by Manish Sharma


PL/SQL Tutorial 43:- Calling Notation for PL/SQL Subroutines in Oracle Database

Calling Notation for PL/SQL Subroutines in Oracle Database By Manish Sharma


PL/SQL Tutorial 44:- Introduction to PL/SQL Packages in Oracle Database

With this PL/SQL Tutorial I am starting a new series about the most demanded tutorials on my YouTube channel which is the PL/SQL Packages.


PL/SQL Tutorial 45:- How to Create PL/SQL Packages in Oracle Database

Learn how to create a PL/SQL Package and how to access it's elements into your code?


PL/SQL Tutorial 46:- Introduction to PL/SQL Exception Handling in Oracle Database

Introduction to PL/SQL Exception Handling In Oracle Database.


PL/SQL Tutorial 47:- How to declare user-define exception using an exception variable in Oracle Database

Learn how to create user-define PL/SQL exception using Variable of Exception Datatype in Oracle Database


PL/SQL Tutorial 48:- How to declare user-define exception using an RAISE_APPLICATION_ERROR in Oracle Database

Learn how to create user-define PL/SQL exception using RAISE_APPLICATION_ERROR in Oracle Database


PL/SQL Tutorial 49:- How to declare user define exception using PRAGMA EXCEPTION INIT in oracle database

In this blog I have explained the concept of PRAGMA EXCEPTION_INIT in detail.


PL/SQL Tutorial 50:- Introduction to PL/SQL Collections in oracle database

From this blog I started a new series on another most demanded topic "The Collections"





  • 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