DECODE_ORACLE()

Overview

In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS:

This takes an expression and one or more pairs of "match,return" values to compare against the expression and returns either the first matching "return" value or NULL.

In 10.2 ES, 10.2 CS:

Not present

See also: Functions in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

EXAMPLES

SELECT DECODE_ORACLE('a','a',1,2) AS a;
+---+
| a |
+---+
| 1 |
+---+
SELECT DECODE_ORACLE('a','ab',1,2) AS a;
+---+
| a |
+---+
| 2 |
+---+
SET sql_mode=CONCAT(@@sql_mode, ',ORACLE');
SELECT DECODE(1,01,1,2) AS a;
+---+
| a |
+---+
| 1 |
+---+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Added in MariaDB Community Server 10.3.2.

10.2 Enterprise

  • Not present.

10.2 Community

  • Not present.

EXTERNAL REFERENCES