Re: Removing blank spaces from a column ?

VampireD schrieb:
>
> I assume you mean the data in the columns.
> There isn't a command I know off.
>
> But you can read the column into a record and then trim it, then update.
>
> > ie I would like to remove all the blank spaces
> > from the following column...
> >
> > 12 12 12 12 12 to make 1212121212

What about

select replace ('12 12 12 12 12', ' ', '') from dual

??

Regards, Stephan

-- 
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Solutions GmbH
fon: +49 30 549932-0           | Landsberger Allee 366
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------