Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

LTRIM(x [, trim_string]) trim characters from the left of x

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>