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);

總結

以上是生活随笔為你收集整理的oracle对比两列数据_oracle与mysql对同一张表 两列数据的某一字段进行值的交换的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。