To the point guide to PL/SQL

What is PL/SQL?

What is a PL/SQL?

The PL/SQL language was developed by Oracle Corporation in 1980s and is an extension of structured Query Language (SQL).It is designed for Database program oriented activities which is mainly used to perform data manipulation.

PL/SQL Advantages are:

  • PL/SQL allows to manage with errors hence user can provide user friendly error messages. By using PL/SQL user can improve the performance of application.
  • PL/SQL has ability to send a set of statements and execute it at once in the Oracle engine.
  • PL/SQL is a tool for controlling, manipulating, and validating data from the database.
  • PL/SQL is not only for manipulation of data but allows supports for branching/looping activities and condition checking.
  • PL/SQL also support for Object-Oriented Programming and for Developing Server Pages and Web Applications.
  • Products are developed in PL/SQL are portable in any Operating system.

PL/SQL Features:

The features are:

  • It supports extensive error checking.
  • By using PL/SQL user can develop web applications and server pages.
  • It supports number of data types.
  • It also supports structured programming by using procedures and functions.


This tutorial focus on PL/SQL and covers the below topics

  • What is PL/SQL?
  • Environment Setup
  • Variables
  • Data Types 
  • Constants 
  • Operators
  • Conditions
  • Loops
  • Strings
  • Arrays
  • Procedures
  • Functions
  • Cursors
  • Records
  • Exceptions
  • Packages
  • Triggers
  • Collections
  • Transactions
  • Date & Time
  • Object Oriented
  • DBMS Output

If you found any error with any of the docs please let us know.


Learning Objectives

Learn PL/SQL from a beginners perspective, this guide can also help you if you are trying to brush up your PLSQL skills

Author: Subject Coach
Added on: 20th Apr 2015

You must be logged in as Student to ask a Question.

None just yet!