Oracle PL/SQL Ltrim Function

The Ltrim function removes all specified characters from the left-hand side of a string.

The Ltrim Function syntax:

ltrim( string, [ trim_text ] )

String is the string to trim the characters from the left-hand side.

Trim_text is the string that will be removed from the left-hand side of string.

Example:

select ltrim('  oracle') from dual;
would return 'oracle'

select ltrim('000database', '0') from dual;
would return 'database'

select ltrim('878878Java', '878') from dual;
would return 'Java'

select ltrim('878878Java878', '878') from dual;
would return 'Java878'

select ltrim('abccbabcaabbForms', 'abc') from dual;
would return 'Forms'

select ltrim('7651234123Asp', '0123456789') from dual;
would return 'Asp'