Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: removing all spaces in a string
Sebastian Scholz wrote:
> Hello,
>
> How do I remove all Spaces in a String?
>
> Sebastian
18:30:55 dev:drake> select replace('this string has spaces',' ') from dual;
REPLACE('THISSTRING
that string no longer has spaces :)
Paul Received on Sun Aug 05 2001 - 17:47:12 CDT