Getting started PL/SQL tutorial for beginners as well as cover advanced topics such as PL/SQL data types, conditions and looping, type of cursor, how to handling PL/SQL exceptions, how to define PL/SQL functions, procedures, packages, and PL/SQL Trigger.
What is PL/SQL?
PL/SQL is a Procedural Language extension of Structured Query Language (SQL).
PL/SQL (Procedural Language/Structured Query Language) program executes on Oracle database.
PL/SQL is specially designed for Database oriented activities. Oracle PL/SQL allows you to perform data manipulation operation those are safe and flexible.
PL/SQL come after releasing Oracle database (version 7). The basic structure block of PL/SQL built using DECLARE, BEGIN, EXCEPTION(optional), END keywords. This keyword block are defined as a declaration block, executable block, exception handling block and last end block (for end of the structure).
Basic SQLPL/SQL Advantages
PL/SQL Block Structure
PL/SQL Variable & Scope
PL/SQL Constant Declaration
PL/SQL serveroutput ON
PL/SQL Condition, Looping, Sequential Case
PL/SQL Transaction, Cursor, Exception