Ltrim: removes a set of characters from the left of a string : LTRIM « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. LTRIM

Ltrim: removes a set of characters from the left of a string

 
SQL>
SQL> -- Ltrim: removes a set of characters from the left of a string.
SQL>
SQL>
SQL> -- LTRIM stands for "left trim."
SQL> -- The general format for this function is:
SQL>
SQL> -- LTRIM(string, characters_to_remove)
SQL>
SQL> SELECT LTRIM('...Mitho', '.') FROM dual;

LTRIM
-----
Mitho

SQL>








Related examples in the same category

1.LTRIM function removes leading characters
2.select '"' || ltrim( ' Some String' ) || '"' "A String"
3.LTRIM and RTRIM
4.LTRIM('ABCBCA12345', 'ABC')
5.LTRIM('OPS$SPORANO', 'OPS$')
6.Trim letter S from both sides