Re: SQL IN ORACLE

From: Klaus Zeuch <KZeuchnospam_at_hotmail.com>
Date: Fri, 23 Feb 2001 13:37:25 +0100
Message-ID: <975omj$9k5$1@papyrus.erlm.siemens.de>

I think that syntax won't work with any dbms following ansi-rules.

Solution for oracle:

update table1 t1
set t1.col1 = (
select t2.col1
from table2 t2
where t2.primary_key = t1.primary_key)

Klaus

ap <alberto_at_momax.it> schrieb in im Newsbeitrag: 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)
>
> THE ERROR MESSAGE IS :
> INVALID COLUMN NAME
>
> EXISTS ANOTHER SIMILAR SQL FOR UPDATE
> FROM ONE TABLE TO ANOTHER IDENTICAL TABLE ???
>
> TANKS
>
>
Received on Fri Feb 23 2001 - 06:37:25 CST