LTRIM function removes leading characters : LTRIM « Char Functions « Oracle PL / SQL






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

LTRIM function removes leading characters

 

SQL>
SQL> --LTRIM function removes leading characters
SQL>
SQL> SELECT LTRIM('ST' , 'STEVENS') AS TRIM FROM Dual;

T
-


SQL>








Related examples in the same category

1.Ltrim: removes a set of characters from the left of a string
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