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.
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.
In this release, Oracle has extended support of PL/SQL-only data types to dynamic SQL and client programs (OCI or JDBC). For example, you can bind collections vari-ables when using the EXECUTE IMMEDIATE statement or the OPEN FOR, FETCH, and CLOSE 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.
Contents at a Glance Foreword to the OakTable Press Series. . . . . . . . . . . . . . . . . . . . . . . . . . . .ix About the Authors ...
This tutorial shows you how to use PL/SQL IF statements with three forms: IF-THEN, IF-THEN-ELSE and IF-THEN_ELSEIF statements.