Trim space from a string
SQL> SQL> select '"' || trim( ' ' from ' This is a string ' ) || '"' "Result" 2 from dual 3 / Result ------------------ "This is a string" 1 row selected. SQL> --