Ternary conditional operator: Difference between revisions

Revision as of 06:45, 26 May 2023

Revision as of 05:46, 19 June 2023

Line 781:

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="oracle8sql">

-- General syntax takes case-result pairs, comparing against an expression, followed by a fall-back result:

DECODE(expression, case1, result1,