Update table with multiple columns from - Ask Tom - Oracle

28 Jun 2005 ... i.e, one column of a table should get updated from another column of another table. ..... SQL> update ( select * from t1, t2 where t1.x = t2.a ) 2 set y = b; set y = b * ERROR at line 2: ...

asktom.oracle.com