PL/SQL Function is same as PL/SQL Procedure, The only difference is that function must return a value and a procedure…
PL/SQL Procedure Previously I have posted about PL/SQL Block structure, A piece of code that is organized in a properly…
PL/SQL Exceptions An error that occurs during execution of the program is called exception, Like other programming languages, PL/SQL offers…
In PL/SQL Basic Exit Loop all statements inside the block are executed at least once before loop termination, Basic loop…
PL/SQL WHILE loop is used to execute statements as long as given condition is true and the condition is checked…
PL/SQL For loop is used when we need to execute set of statements for the specific number of times and…