select '"' || ltrim( ' Some String' ) || '"' "A String" : LTRIM « Char Functions « Oracle PL / SQL






select '"' || ltrim( ' Some String' ) || '"' "A String"

  
SQL>
SQL> select '"' || ltrim( '    Some String' ) || '"' "A String" from dual;
A String
-------------
"Some String"

1 row selected.

SQL>
SQL> --

   
  








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