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 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).


Introduction PL/SQL
Basic PL/SQL
PL/SQL Advantages
PL/SQL Block Structure
PL/SQL Variable & Scope
PL/SQL Constant Declaration
PL/SQL serveroutput ON
PL/SQL Comment
   
PL/SQL Data Types
PL/SQL Data Types
Scalar types
Numeric Datatypes
Character Datatypes
Boolean Datatypes
Date/Time Datatypes
LOB types
User-Defined Subtypes
PL/SQL Condition Looping Sequential Case
PL/SQL Conditional Control
IF THEN ELSE Statement
IF THEN ELSE Statement
IF THEN ELSIF Statement
Nested IF THEN ELSE Statement
   
PL/SQL Loop Statement   
Basic LOOP
WHILE LOOP
FOR LOOP
PL/SQL Case Statement
Simple CASE Statement
Searched CASE Statement
   
PL/SQL Sequential Control
EXIT Statement
EXIT WHEN Statement
CONTINUE Statement
CONTINUE WHEN Statement
GOTO Statement
PL/SQL Transaction Cursor Exception
PL/SQL Transaction   
COMMIT
ROLLBACK
SAVEPOINT
AUTOCOMMIT
SET TRANSACTION
   
PL/SQL Cursors
Implicit Cursors
Explicit Cursors
For Loop Cursors
Parameterized Cursors
   
PL/SQL Exception
User Defined Exception
User Named Exception

Advance PL/SQL
PL/SQL Procedures
Procedure Syntax
Procedure Example
Procedure Drop
   
PL/SQL Functions
Function Syntax
Function Example
Function Drop
   
PL/SQL Packages
Packages Advantages
Packages Syntax
Packages Example
Packages Alter
Packages Drop
   
PL/SQL Triggers
Triggers Type
Triggers Syntax
Triggers Examples