LTRIM('ABCBCA12345', 'ABC') : LTRIM « Char Functions « Oracle PL / SQL






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

LTRIM('ABCBCA12345', 'ABC')

  
SQL>
SQL> SELECT LTRIM('ABCBCA12345', 'ABC')
  2  FROM   DUAL;

LTRIM
-----
12345









                                                                                                                                      Page           1








Related examples in the same category

1.Ltrim: removes a set of characters from the left of a string
2.LTRIM function removes leading characters
3.select '"' || ltrim( ' Some String' ) || '"' "A String"
4.LTRIM and RTRIM
5.LTRIM('OPS$SPORANO', 'OPS$')
6.Trim letter S from both sides