Conditional Expressions
Conditional expressions return values that depend on the outcome of conditional tests. This
diagram shows the syntax for Conditional Expressions.
Conditional Expressions
1 %CASE Expressions1
1 %COALESCE Function2
1 %NVL Function3
1 %NVL2 Function4
1 %NULLIF Function5
1 %DECODE Function6
CASE Expressions COALESCE Function NVL Function NULLIF Function DECODE Function DECODE expression is similar to the CASE expression in that it can print different results depending on the values found in a specified column.Have feedback? Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.