Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

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>