DECODE_ORACLE()

Overview

In 11.4 ES, 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 11.4 ES, 10.6 ES, 10.5 ES, 10.4 ES:

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

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

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 |
+---+

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

11.4 Enterprise

  • Not present.

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.

Release Series

History

11.4 Enterprise

  • Not present.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES