OraFAQ Forum: SQL & PL/SQL » Update from multiple tables

Home » SQL & PL/SQL » SQL & PL/SQL » Update from multiple tables

Wed, 03 April 2002 07:07

LI810
Messages: 25
Registered: February 2002

Junior Member

How I can update one table from several tables:

update a
from a,b,c,
set a.field1=b.field1
where a.key=b.key and b.key1=c.key1;

Wed, 03 April 2002 08:06

Skumar
Messages: 17
Registered: April 2002

Junior Member

update table1 tab1
set col1= (select a from table2 tab2 where tab2.key=tab1.key),
col2 = (select b from table3 tab3 where
tab3.key = tab1.key)
/

Previous Topic:	Update Data Script -- Help !!!
Next Topic:	how can i create view in function??

Goto Forum:

]

Current Time: Sat May 04 08:18:31 CDT 2024