PL/SQL Ltrim

The Ltrim function removes characters from the left-hand side of an expression.

Ltrim syntax

LTRIM( expression, [ trim_expression ] )

Ltrim example

select ltrim(' example') from dual;

Result: example


select ltrim('000function', '0') from dual;	

Result: function


select ltrim('123SQL', '123') from dual;	

Result: SQL


select ltrim('123123SQL123', '123') from dual;	

Result: SQL123


select ltrim('XYZxyzTest', 'XYZ') from dual;	

Result: xyzTest


select ltrim('xyzzxyxxzzyyxTest', 'xyz') from dual;	

Result: Test


select ltrim('12345Oracle', '0123456789') from dual;	

Result: Oracle

↑