SUBSTR_ORACLE()

This page is part of MariaDB's MariaDB Documentation.

The parent of this page is: Functions

Topics on this page:

Overview
EXAMPLES
CHANGE HISTORY

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:: A description for this Function has not yet been added to this Documentation.

In 10.6 ES, 10.5 ES, 10.4 ES:: A description for this Function has not yet been added to this Documentation.

In 10.2 ES, 10.2 CS:: Not present

See also: Functions in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

SELECT SUBSTR_ORACLE('mariadb',1);

+----------------------------+
| SUBSTR_ORACLE('mariadb',1) |
+----------------------------+
| mariadb                    |
+----------------------------+

SELECT SUBSTR_ORACLE('mariadb',2);

+----------------------------+
| SUBSTR_ORACLE('mariadb',2) |
+----------------------------+
| ariadb                     |
+----------------------------+

SET sql_mode=CONCAT(@@sql_mode, ',ORACLE');
SELECT SUBSTR('mariadb',-2);

+----------------------+
| SUBSTR('mariadb',-2) |
+----------------------+
| db                   |
+----------------------+

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.3.
10.2 Enterprise	Not present.
10.2 Community	Not present.

Release Series	History
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.