PL/SQL

PL/SQL Tutorial index


What is PL/SQL


Introduction of PL/SQL.

Variable in PL/SQL


Variables of PL/SQL.

Use of %TYPE Attribute.

Bind Variable in PL/SQL.

Different Scalar Data Types.

Lexical unit in PL/SQL


Lexical unit in PL/SQL.

Using SQL function in PL/SQL


Using SQL function in PL/SQL.

Use of sequence in PL/SQL.

Nested Block in PL/SQL.

Use of Select statement in PL/SQL.

 

Manipulating data with DML statement in PL/SQL


Manipulate data with DML statements in PL/SQL.

What is cursor and Types of Cursor in PL/SQL


PL/SQL Cursors.

Control statement in PL/SQL


Use of Control statement in PL/SQL.

PL/SQL LOOP


Use of PL/SQL LOOP Statement.

PL/SQL Basic LOOP.

PL/SQL While LOOP

FOR LOOP for PL/SQL.

What is PL/SQL Continue statement?

Anonymous Block Example in PL/SQL


Different Anonymous Blocks in PL/SQL.

PL/SQL Procedure and  function


What is PL/SQL Subprograms?

What Are Procedures in PL/SQL?

Use of PL/SQL Function.

PL/SQL Package Example


PL/SQL package.

Exception Example IN PL/SQL and How can we handle it


What is Exception in PL/SQL?