oracle 字符串转为数字排序

select * from user order by  to_number(dept_id) asc

原文地址:https://www.cnblogs.com/hxun/p/11458251.html