Character String Functions Oracle PLSQL Tutorial

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>