Clarifies a conditional expression. FALSE is equivalent to the integer 0.

The following example uses FALSE in a DECODE expression to verify that values are between 25 and 30. This is useful if you want to perform multiple searches based on a single search value:

DECODE (FALSE,

Var1 >= 25, 'Var1 not in desired range.',

Var1 <= 30, 'Var1 not in desired range.',

'Var1 in desired range.')

Var1 >= 25, 'Var1 not in desired range.',

Var1 <= 30, 'Var1 not in desired range.',

'Var1 in desired range.')

© Copyright Informatica LLC 2007, 2021