Re: Update Oracle table to remove whitespace using trim function

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 Tue Aug 01 2006 - 16:12:07 CDT