Use rtim to remove space : RTRIM « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. RTRIM

Use rtim to remove space

 
SQL>
SQL>  select '"' || rtrim( 'Some String     ' ) || '"' "A String"
  2      from dual
  3    /
A String
-------------
"Some String"

1 row selected.

SQL>
SQL> --








Related examples in the same category

1.Rtrim: removes a set of characters from the right of a string
2.RTRIM function removes trailing characters
3.Rtrim char type column data