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.
- PL/SQL CASE Statement
Summary: in this tutorial, you will learn how to use the...
- PL/SQL CASE Statement
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.
This Oracle tutorial explains how to use the IF-THEN-ELSE statement in Oracle with syntax and examples. In Oracle, the IF-THEN-ELSE statement is used to execute code when a condition is TRUE, or execute different code if the condition evaluates to FALSE.
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.