Conditional Expressions

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

Conditional Expressions

Notes:

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