Search results
PL/SQL IF THEN ELSE statement. The IF THEN ELSE statement has the following structure: IF condition THEN statements; ELSE else_statements; END IF; Code language: PostgreSQL SQL dialect and PL/pgSQL (pgsql) If the condition evaluates to TRUE, then the statements between THEN and ELSE execute.
For example, database triggers (code that is attached to tables discussed in Chapter 13, “Trig-gers,” and Chapter 14, “Mutating Tables and Compound Triggers”) on the server side and the logic behind an Oracle form on the client side can be written using PL/SQL.
• Construct and use an IF-THEN-ELSE statement • Create PL/SQL to handle the null condition in IF statements 3
This tutorial shows you how to use PL/SQL IF statements with three forms: IF-THEN, IF-THEN-ELSE and IF-THEN_ELSEIF statements.
Example 4-2 IF THEN ELSE Statement. In this example, the statement between THEN and ELSE runs if and only if the value of sales is greater than quota+200; otherwise, the statement between ELSE and END IF runs.
Oracle PL/SQL by Example, Sixth Edition, teaches all the PL/SQL skills you'll need, through real-world labs and extensive examples. Now fully updated for the newest version of PL/SQL 21c, it covers everything from basic syntax and program control through the latest optimization and tuning enhancements.
Syntax for the IF-THEN-ELSE statement is −. IF condition THEN S1; ELSE S2; END IF; Where, S1 and S2 are different sequence of statements. In the IF-THEN-ELSE statements, when the test condition is TRUE, the statement S1 is executed and S2 is skipped; when the test condition is FALSE, then S1 is bypassed and statement S2 is executed. For ...
