Editing Ternary conditional operator (section)

====Oracle SQL====
In addition to the standard {{code|CASE}} expression, Oracle has a [[variadic function]]al counterpart which operates similarly to a [[switch statement]] and can be used to emulate the conditional operator when testing for equality.

<syntaxhighlight lang="sql">
-- General syntax takes case-result pairs, comparing against an expression, followed by a fall-back result:
DECODE(expression, case1, result1,
                   ...
                   caseN, resultN,
                          resultElse)

-- We can emulate the conditional operator by just selecting one case:
DECODE(expression, condition, true, false)
</syntaxhighlight>

The {{code|DECODE}} function is, today, deprecated in favour of the standard {{code|CASE}} expression. This can be used in both Oracle SQL queries as well as [[PL/SQL]] blocks, whereas {{code|decode}} can only be used in the former.