Home -> Usenet -> comp.databases.oracle -> Update statmennt on ORACLE 7.1

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> 






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












Original text of this message