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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL IN ORACLE

Re: SQL IN ORACLE

From: Spencer <spencerp_at_swbell.net>
Date: Sat, 24 Feb 2001 17:04:19 -0600
Message-ID: <y5Xl6.111$Hx2.88431@nnrp2.sbc.net>

"ap" <alberto_at_momax.it> wrote in message news:975fed$re3$1_at_fe1.cs.interbusiness.it...
> WHY THIS SQL NOT RUNNING IN ORACLE???
>
> UPDATE table_dest A
> SET A.column_1 = B.column_1
> WHERE EXISTS
> ( SELECT * FROM table_orig B
> WHERE A.PK=B.PK)
it won't run because it is an invalid SQL statement. that's why.

>
> THE ERROR MESSAGE IS :
> INVALID COLUMN NAME
>
> EXISTS ANOTHER SIMILAR SQL FOR UPDATE
> FROM ONE TABLE TO ANOTHER IDENTICAL TABLE ???
>
> TANKS
>

you could try a statement something like this:

UPDATE table_dest A

   SET A.column_1 = (SELECT B.column_1

                       FROM table_orig B
                      WHERE A.PK = B.PK)
HTH Received on Sat Feb 24 2001 - 17:04:19 CST

Original text of this message

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