An error that occurs during execution of the program is called exception, Like other programming languages, PL/SQL offers a way to catch these exceptions and handle them.
PL/SQL FOR loop is used when we need to execute set of statements for the specific number of times and loop operates between the start and end counter values. The counter is always increm ...
In PL/SQL Basic Loop all statements inside the block are executed at least once before loop termination, Basic loop encloses statement between LOOP and END LOOP and there must be an EXIT ...
PL/SQL WHILE loop is used to execute statements as long as given condition is true and the condition is checked at the beginning of each iteration
Loops are used to repeat execution of a statement or a set of statements multiple times on base of a condition or expression
Like real life in programming sometimes we need to execute some code on a specific condition, PL/SQL CASE statement allows us to execute a sequence of instructions based on a selector (A ...
Like other programming languages, PL/SQL supports decision making statements, These statements are also called conditional statement
A variable in any programming language is the name of space where values are stored and controlled by our code/program
PL/SQL is highly structured language and it's program units are written in block of code, In this tutorial we'll learn about basic syntax and block structure of PL/SQL
PL/SQL is developed by Oracle Corporation to increase/enhance capabilities of SQL, PL/SQL stands for