Re: Update Oracle table to remove whitespace using trim function

Thanks to all responses. this one worked like a charm.

There was no need for a subselect, I simply haven't written a query like the below in years and forgot how to sanitize existing data that way.

btw, I'm on Oracle 9i and my error message was just 01427, single row subquery returns more than one row. When I saw that I realized I was off-base.

thanks!

Don

G Quesnel wrote:
> Can you show us what you have tried,
> and why do you think you need a sub select ?
> To simply remove spaces from the front and/or end of a column is
> trivial ...
> ex: update mytable set colx = trim(colx);
>
> You could even only update rows that require triming, with something
> like...
> update mytable
> set colx = trim(colx)
> where length(colx) > length(trim(colx));
>
> HTH
Received on Wed Aug 02 2006 - 09:15:09 CDT