IF

Execute code based on conditions. This control flow statement runs different blocks of SQL statements depending on whether a specified condition is true.

Syntax

IF search_condition THEN statement_list
    [ELSEIF search_condition THEN statement_list] ...
    [ELSE statement_list]
END IF

Railroad diagram of the IF statement — equivalent to the BNF above

Description

IF implements a basic conditional construct. If the search_condition evaluates to true, the corresponding SQL statement list is executed. If no search_condition matches, the statement list in the ELSE clause is executed. Each statement_list consists of one or more statements.

See Also

• The IF() function, which differs from the IF statement described above.

• Changes in Oracle mode.

• The CASE statement.

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}