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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Update Oracle table to remove whitespace using trim function

Re: Update Oracle table to remove whitespace using trim function

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 01 Aug 2006 16:06:31 -0700
Message-ID: <1154473582.433406@bubbleator.drizzle.com>


bbcrock_at_gmail.com wrote:
> I want to update one column in a table using the trim function. I
> tried to write an update with a subselect but it failed. Does anyone
> have code to do this or can you point me to an article about this?
>
> thanks,
>
> Don

Post your attempt, post the error message you received (the real one) and your Oracle version number.

Update demos can be found in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Aug 01 2006 - 18:06:31 CDT

Original text of this message

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