--- ORACLE UPDATE JOINED TABLES
update
(
select a.UPDATE_NEED_COLUMN "X",b.UPDATE_INFO "Y"
from TABLE1 a, TABLE2 b
where a.ID=b.ID
)
set
X=Y;
update
(
select a.UPDATE_NEED_COLUMN "X",b.UPDATE_INFO "Y"
from TABLE1 a, TABLE2 b
where a.ID=b.ID
)
set
X=Y;
Etiketler :
Oracle