PL/SQL Procedure

A subprogram is a module or a small unit/part of a program that performs a particular task. In modular programming, a program can optionally consist of multiple subprograms. Note: A schema level subprogram is a standalone subprogram. PL/SQL Procedure A procedure is a group of PL/SQL statements that you can call by its name. These …

PL/SQL Procedure Read More »

PL/SQL Loops

There may arise a situation when you need to execute a particular block of code several number of times. Programming languages provide various control structures that allow for more complicated execution paths and Loops are one of them. In other words, you may sometimes need to run a particular block of code in the program …

PL/SQL Loops Read More »

PL/SQL Conditional Statements

Decision-Making is an important part for most of the computer programs. It helps to develop the program code logically. For correct decision making, PL/SQL provides us with the Conditional Statements. These Conditional Statements helps us to develop a proper algorithm and a logical program. Decision-making programs or structures require that the developer mentions conditions to …

PL/SQL Conditional Statements Read More »