SQL>SQL> select trim( trailing ' ' from 'This is a string ' ) "Result" 2 from dual 3 /Result----------------This is a string1 row selected.SQL>SQL> --