Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. Ltrim removes a set of characters from the left of a string
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>