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> --