Oracle Database Tutorials

PL/SQL Tutorials for Beginners

PL/SQL Tutorial list



How To Connect With The Database Using SQL*Plus

Learn How to connect With the database using SQL*Plus Using Users Such as SYS, HR etc. With very Easy Examples


Copy table with or without data using Create Table AS command

Learn How to copy table with or without data using Create Table AS command By Manish Sharma.


PL/SQL Tutorial 1:- Block Types In PL/SQL

Blocks are basic programming unit in PL/SQL Read and learn more about Block Types By Manish Sharma.


PL/SQL Tutorial 2:- Variables In PL/SQL

Learn proper way of Declaring and Initializing Variables in PL/SQL By Manish Sharma.


PL/SQL Tutorial 3:- SELECT...INTO Statement of PL/SQL

Learn how to fetch values from a table into the variable Using SELECT...INTO statement in PL/SQL By Manish Sharma.


PL/SQL Tutorial 4:- Anchored Datatype (%TYPE) In PL/SQL

Anchored Datatype a.k.a %Type in PL/SQL read and learn what are anchored datatype and how to declare them with simple examples in PL/SQL By Manish Sharma.


PL/SQL Tutorial 5:- Constants In PL/SQL

Learn What are Constants how to declare and initialize them in PL/SQL By Manish Sharma.


PL/SQL Tutorial 6:- Bind Variables In PL/SQL

Learn concepts of Bind Variable, Variable Commands, Print and Auto Print command and conqure the Exam as well as Interview


PL/SQL Tutorial 7:- Conditional Control Statements- The Intro

Introduction of Conditional Control Statements In PL/SQL.


PL/SQL Tutorial 8:- Simple IF-THEN Control Statements In PL/SQL

Learn the concept of simple IF-THEN Statements in PL/SQL with Examples


PL/SQL Tutorial 9:- IF-THEN-ELSE Control Statements In PL/SQL

Learn the concept of IF-THEN-ELSE Statements in PL/SQL with Examples


PL/SQL Tutorial 10:- IF-THEN-ELSIF Statements In PL/SQL

IF-THEN-ELSIF Statements in PL/SQL with Examples





  • 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