PL/SQL Tutorial - Getting Started PL/SQL Tutorial
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.
PL/SQL (Procedural Language/Structured Query Language) program executes on Oracle database.
PL/SQL includes procedural language elements (like declaration, conditions, looping), also, you can able to handle a runtime exception.
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