oracle与mysql对同一张表 两列数据的某一字段进行值的交换

mysql的：

UPDATE ops_menu AS per JOIN ops_menu AS next ON (per.menu_id = 1 AND next.menu_id = 11) OR (per.menu_id =11 AND next.menu_id = 1)
   SET per.order_num = next.order_num, next.order_num = per.order_num

 

oracle的：

update ops_menu per
set per.order_num= case when per.menu_id=1 then (select order_num from ops_menu where menu_id=11)
      when per.menu_id=11 then (select order_num from ops_menu where menu_id=1)
     else null
     end
       
where per.menu_id in (1,11);