Conditional Expressions

Conditional expressions return values that depend on the outcome of conditional tests. This diagram shows the syntax for Conditional Expressions.

Read syntax diagram

Skip visual syntax diagram

Conditional Expressions

Read syntax diagram

Skip visual syntax diagram

Notes:

¹ See CASE Expressions
² See COALESCE Function
³ See NVL Function
⁴ See NVL2 Function
⁵ See NULLIF Function
⁶ See DECODE Function

CASE Expressions
The CASE expression allows an SQL statement such as the SELECT statement to return one of several possible results, depending on which of several conditions evaluates to true.
COALESCE Function
The COALESCE function returns the first non-NULL value from a series of expressions.
NVL Function
NULLIF Function
DECODE Function
The DECODE expression is similar to the CASE expression in that it can print different results depending on the values found in a specified column.

Parent topic: Expression