LTRIM(x [, trim_string]) trim characters from the left of x. : LTRIM « Character String Functions « Oracle PL/SQL Tutorial






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

You can supply an optional trim_string that specifies the characters to trim.

If no trim_string is supplied, spaces are trimmed by default.

SQL> SELECT
  2    LTRIM('  Hello ')
  3  FROM dual;

LTRIM(
------
Hello

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