Re: SQL IN ORACLE

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Fri, 23 Feb 2001 11:50:13 GMT
Message-ID: <3a964a84.11102534@news-server>

On Fri, 23 Feb 2001 11:58:28 +0100, "ap" <alberto_at_momax.it> wrote:

>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)
>
>THE ERROR MESSAGE IS :
>INVALID COLUMN NAME
>
>EXISTS ANOTHER SIMILAR SQL FOR UPDATE
>FROM ONE TABLE TO ANOTHER IDENTICAL TABLE ???
>

Jeez, don't shout! Or take some lithium.

Try:
UPDATE tdest A
SET A.col1 = (SELECT B.col1

              FROM torig B
              WHERE B.PK = A.PK)

WHERE EXISTS
(SELECT 1 FROM torig C
WHERE A.PK = C.PK); That should work.
Or use a PL/SQL block, join the two tables on PK, then update for every record found.
HTH Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri Feb 23 2001 - 05:50:13 CST