UPDATE
/*+ bypass_ujvc */
( SELECT a.content,b.content as or_content
  FROM tb_table1 a, tb_table2 b
 WHERE a.or_no IN ('201205020001')
   AND a.id = b.ep_id
)
SET  content = or_content  ;

서브쿼리보다 훨씬 빠르다.