PL/SQL - IF-THEN Statement - Tutorialspoint.

PL/SQL - IF-THEN Statement - It is the simplest form of the IF control statement, frequently used in decision-making and changing the control flow of the program execution. The function IIF returns one of 2 values depends of the evaluation of an expression. This is not a standard SQL function and exist for compatible with MS Access. SQL Server IIF function will accept three arguments. The first argument is the Boolean expression, which returns true or false. If the expression results TRUE, then.

Summary: in this tutorial, you will learn how to use the PL/SQL IF statement to either execute or skip a sequence of statements based on a specified condition. The IF statement allows you to either execute or skip a sequence of statements, depending on a condition. The IF statement has the three forms: – IF THEN – IF THEN ELSE – IF THEN ELSIF PL/SQL IF THEN statement.