Like the IF statement, the CASE statement selects one sequence of statements to execute. However, to select the sequence, the CASE statement uses a selector rather than multiple Boolean expressions. A selector is an expression, the…
TheĀ IF-THEN-ELSIFĀ statement allows you to choose between several alternatives. AnĀ IF-THENĀ statement can be followed by an optionalĀ ELSIF...ELSEĀ statement. TheĀ ELSIFĀ clause lets you add additional conditions. When usingĀ IF-THEN-ELSIFĀ statements there are a few points to keep…
A sequence ofĀ IF-THENĀ statements can be followed by an optional sequence ofĀ ELSEĀ statements, which execute when the condition isĀ FALSE. Syntax The syntax for the IF-THEN-ELSE statement is ā IF condition THEN S1; …
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 IF statement associates a condition with a sequence of statements…
In this chapter, we will discuss conditions in PL/SQL. Decision-making structures require that the programmer specify one or more conditions to be evaluated or tested by the program, along with…
Operator precedence determines the grouping of terms in an expression. This affects how an expression is evaluated. Certain operators have higher precedence than others; for example, the multiplication operator has…
The following table shows the Logical operators supported by PL/SQL. All these operators work on Boolean operands and produce Boolean results. Assume variable A holds true and variable B holds…
Comparison operators are used for comparing one expression to another. The result is always eitherĀ TRUE, FALSE,Ā orĀ NULL. OperatorDescriptionExampleLIKEThe LIKE operator compares a character, string, or CLOB value to a pattern and…
Relational operators compare two expressions or values and return a Boolean result. The following table shows all the relational operators supported by PL/SQL. Let us assumeĀ variable AĀ holds 10 andĀ variable BĀ holds…
The following table shows all the arithmetic operators supported by PL/SQL. Let us assumeĀ variable AĀ holds 10 andĀ variable BĀ holds 5, then ā OperatorDescriptionExample+Adds two operandsA + B will give 15-Subtracts second…