Update statmennt on ORACLE 7.1
From: Sven Brenna <svb_at_siemensnixdorf.no>
Date: Thu, 24 Nov 1994 07:19:12
Message-ID: <1994Nov24.061834.21879_at_ncn.siemens-nixdorf.no>
The Document is dead. Long live the document.
Received on Thu Nov 24 1994 - 07:19:12 CET
Date: Thu, 24 Nov 1994 07:19:12
Message-ID: <1994Nov24.061834.21879_at_ncn.siemens-nixdorf.no>
I wonder if anybody can give me an answer to this problem:
In Sybase you can write following statment
update table A set col3 = X from table A, table B where A.c1 = B.c1 and A.c2 = B.c2 and ......( more conditions)
The point is that you can use more than one table in the update statment. In Oracle 7.1 you can use subqueries, but the join I need to do have to columns as primary key.
Sven Brenna
DocuLive
Siemens Nixdorf Informasjonssystemer A/S, Norway
The Document is dead. Long live the document.
Received on Thu Nov 24 1994 - 07:19:12 CET