Oracle按数字大小排序

order by  CAST   (   id AS  int   )

原文地址:https://www.cnblogs.com/liyingxian5/p/6555092.html