[oracle] select 해와서 update

select 해와서 update 쿼리

 

 

update  /*+ bypass_ujvc */
  (
    SELECT
          a.napgi_se_cd ra
         ,b.napgi_se_cd rb  
      FROM  a
         ,  b
     WHERE a.key= b.key
) set ra = rb;