In this tutorial, we are going to learn how to use SQL in PL/SQL. SQL is the actual component that takes care of fetching and updating...
Read moreWhat is Exception Handling in PL/SQL? An exception occurs when the PL/SQL engine encounters an instruction which it cannot execute due t...
Read moreIn this tutorial, you are going to see the detailed description on how to create and execute the named blocks (procedures and functions)...
Read moreWhat is While Loop? WHILE loop statement works similar to the Basic loop statement except the EXIT condition is at the very beginning o...
Read moreWhat 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 moreWhat 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 moreWhat is CASE Statement? A CASE statement is similar to IF-THEN-ELSIF statement that selects one alternative based on the condition fro...
Read moreWhat are Decision-Making Statements? Decision making statements are those who will decide the flow-control of SQL statements based on ...
Read moreWhat 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 moreWhat 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