PL/SQL Tutorial

PL/SQL Tutorial

Getting started PL/SQL tutorial. Every PL/SQL tutorial lesson explain step by step with sample example. In this PL/SQL tutorial, you will learn PL/SQL data types, conditions, looping, type of cursor, how to handling PL/SQL exceptions, how to define PL/SQL functions, procedures, packages, and PL/SQL Trigger. Let's start the PL/SQL tutorial.

What is PL/SQL?

PL/SQL stands for a procedural language extension of the structured query language (SQL). PL/SQL (Procedural language/structured query language) is a program to executes in Oracle database.
Furthermore, PL/SQL specially designed for database oriented activities. Also, Oracle PL/SQL allows you to perform data manipulation operation that is safe and flexible.

First of all, PL/SQL comes after releasing Oracle database (version 7). The basic structure block of PL/SQL built using DECLARE, BEGIN, EXCEPTION (optional), END keywords. These keyword blocks defined as a declaration block, executable block, exception handling block, and last end block (for end of the structure).

You will learn following PL/SQL topics in this tutorial.

Above all PL/SQL lesson cover all PL/SQL topics. Before we start PL/SQL, you have to know about SQL. You can learn here first SQL tutorial before start PL/SQL.