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 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.
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.