Oracle(DB관련)
oracle select update
xfree302
2017. 6. 15. 09:07
반응형
oracle select update
UPDATE /*+ bypass_ujvc */
(
SELECT a.con as aa_con, b.con as bb_con
FROM tb_aa a, tb_bb b
WHERE 1=1
AND a.aa_dt = '20150101'
AND a.aa_id = b.bb_id
)
SET aa_con = bb_con;
반응형