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;


반응형