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.
PL/SQL Tutorial
PL/SQL Block Structure and Syntax
PL/SQL Variable Declaration and Variable Scope
How to Declare Constant in PL/SQL
Set serveroutput ON to start PL/SQL
How To Write PL/SQL Comments
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.