LTRIM « Char Functions « Oracle PL / SQL






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('ABCBCA12345', 'ABC')
6.LTRIM('OPS$SPORANO', 'OPS$')
7.Trim letter S from both sides