Oracle LTRIM function.

Preamble

The Oracle/PLSQL LTRIM function removes all specified characters from the left side of the string.

Syntax of the Oracle/PLSQL LTRIM function

LTRIM( string1_id, [ trim_string _id ) )

Parameters and function arguments

• string1_id – a string that is shortened on the left side.
• trim_string _id – is the string that will be removed from the left side of string1. If this parameter is not specified, the LTRIM function will remove all spaces from string1.

The LTRIM function returns a string value.

LTRIM function in the following versions of Oracle/PLSQL

Let’s consider some examples of LTRIM function and learn how to use LTRIM function in Oracle/PLSQL.

SQL> SELECT LTRIM(' ltrim') FROM DUAL;

--Result: ltrim
SQL> SELECT LTRIM(' ltrim', ' " ') FROM DUAL;

--Result: ltrim

SQL> SELECT LTRIM('000123', '0') FROM DUAL;

--Result: 123

SQL> SELECT LTRIM('123123Ltrim', '123') FROM DUAL;

--Result: Ltrim

SQL> SELECT LTRIM('123123Ltrim123', '123') FROM DUAL;

--Result: Ltrim123

SQL> SELECT LTRIM('xyxzyyyyLtrim', 'xyz') FROM DUAL;

--Result: Ltrim

SQL> SELECT LTRIM('6372Ltrim', '0123456789') FROM DUAL;

--Result: Ltrim

About Enteros

​​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​