LPAD_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
EXTERNAL REFERENCES

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 accesses a version of the LPAD function that returns NULL instead of an empty string when returning an empty string.

In 10.6 ES, 10.5 ES, 10.4 ES:: This accesses a version of the LPAD function that returns NULL instead of an empty string when returning an empty string.

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 LPAD_ORACLE('DB',1,'Maria');

+-----------------------------+
| LPAD_ORACLE('DB',1,'Maria') |
+-----------------------------+
| D                           |
+-----------------------------+

SET sql_mode=CONCAT(@@sql_mode, ',ORACLE');
SELECT LPAD('DB',7,'Maria');

+----------------------+
| LPAD('DB',7,'Maria') |
+----------------------+
| MariaDB              |
+----------------------+

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.6.
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.

EXTERNAL REFERENCES

Additional information on this topic may be found in the MariaDB Public Knowledge Base.