Returns a value based on the result of a comparison. TRUE is equivalent to the integer 1.
Example
The following example uses TRUE in a DECODE expression to return values based on the results of a comparison. This is useful if you want to perform multiple searches based on a single search value:
DECODE( TRUE, Var1 = 22,'Variable 1 was 22!', Var2 = 49,'Variable 2 was 49!', Var1 < 23, 'Variable 1 was less than 23.', Var2 > 30, 'Variable 2 was more than 30.', 'Variables were out of desired ranges.')