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: newbie -> question on how-to replace the value in a column

Re: newbie -> question on how-to replace the value in a column

From: ingimar <ingimar_at_ganja.com>
Date: Thu, 18 Apr 2002 16:50:44 +0200
Message-ID: <a9mm8v$kgq$1@yggdrasil.utfors.se>


is it possible to -> update Table set column1=column2 -i
"ingimar" <ingimar_at_ganja.com> wrote in message news:a9ml40$kd3$1_at_yggdrasil.utfors.se...
> Hello,
>
> I have a tool for analyses that creates an oracle-database.
> Looking in table A, I can see that the values in column A1 are wrong -
the
> values were inserted in column A2.
> This messes up the analyses when looking at the values.
>
> So, what I would like to do - is somehow to select the values in column A2
> and insert them into A1.
> Is it hard to do ?
>
> -i
>
>
Received on Thu Apr 18 2002 - 09:50:44 CDT

Original text of this message

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