DECODE()

`DECODE()`

Shorthand “simple CASE”-equivalent function

Result type

Depends on input

Syntax

DECODE(<testexpr>,
  <expr1>, <result1>
  [<expr2>, <result2> ...]
  [, <defaultresult>])

Table 1. `DECODE` Function Parameters
Parameter	Description
testexpr	An expression of any compatible type that is compared to the expressions expr1, expr2 … exprN
expr1, expr2, … exprN	Expressions of any compatible types, to which the testexpr expression is compared
result1, result2, … resultN	Returned values of any type
defaultresult	The expression to be returned if none of the conditions is met

DECODE is a shorthand for the so-called “simple CASE” construct, in which a given expression is compared to a number of other expressions until a match is found.The result is determined by the value listed after the matching expression.If no match is found, the default result is returned, if present, otherwise NULL is returned.

The equivalent CASE construct:

CASE <testexpr>
  WHEN <expr1> THEN <result1>
  [WHEN <expr2> THEN <result2> ...]
  [ELSE <defaultresult>]
END

Caution

Matching is done with the ‘=’ operator, so if testexpr is NULL, it won’t match any of the exprs, not even those that are NULL.

DECODE()

DECODE()

DECODE Examples

`DECODE()`

`DECODE` Examples