Ltrim removes a set of characters from the left of a string : LTRIM « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. LTRIM

LTRIM stands for "left trim." The general format for this function is: LTRIM(string, characters_to_remove)

SQL>
SQL> SELECT LTRIM('...Mitho', '.') FROM dual;

LTRIM
-----
Mitho

SQL>








11.13.LTRIM
11.13.1.LTRIM(x [, trim_string]) trim characters from the left of x.
11.13.2.Ltrim removes a set of characters from the left of a string
11.13.3.Trim leading and ending letters