Tutorials
Oracle PL/SQL Exception Handling: Examples to Raise User-defined Exception
What is Exception Handling in PL/SQL? An exception occurs when the PL/SQL engine encounters an instruction which it cannot execute due t...
Read more
Tutorials
Oracle PL/SQL Stored Procedure & Functions with Examples
In this tutorial, you are going to see the detailed description on how to create and execute the named blocks (procedures and functions)...
Read more
Tutorials
Oracle PL/SQL WHILE LOOP with Example
What is While Loop? WHILE loop statement works similar to the Basic loop statement except the EXIT condition is at the very beginning o...
Read more
Tutorials
Oracle PL/SQL FOR LOOP with Example
What is For Loop? "FOR LOOP" statement is best suitable when you want to execute a code for a known number of times rather tha...
Read more
Tutorials
Oracle PL/SQL LOOP with Example
What are Loops? Loops allows a certain part of the code in a program to get executed for the desired number of times. In this tutorial...
Read more
Tutorials
Oracle PL/SQL: CASE Statement with Examples
What is CASE Statement? A CASE statement is similar to IF-THEN-ELSIF statement that selects one alternative based on the condition fro...
Read more
Tutorials
Oracle PL/SQL IF THEN ELSE Statement: ELSIF, NESTED-IF
What are Decision-Making Statements? Decision making statements are those who will decide the flow-control of SQL statements based on ...
Read more
Tutorials
Oracle PL/SQL Records Type with Examples
What is Record Type? A Record type is a complex data type which allows the programmer to create a new data type with the desired column ...
Read more
Tutorials
Oracle PL/SQL Collections: Varrays, Nested & Index by Tables
What is Collection? A Collection is an ordered group of elements of particular data types. It can be a collection of simple data type ...
Read more
Tutorials
Oracle PL/SQL Variable Identifiers Tutorial with Examples
What is Identifiers? Identifiers are nothing but a name that is given to a PL/SQL object. The object could be constant, variable, exce...
Read more
