Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: removing all spaces in a string

Re: removing all spaces in a string

From: Paul Drake <paled_at_home.com>
Date: Sun, 05 Aug 2001 22:47:12 GMT
Message-ID: <3B6DCD3E.2271FA31@home.com>

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



thisstringhasspaces

that string no longer has spaces :)

Paul Received on Sun Aug 05 2001 - 17:47:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US