myfun() return number;
select *from table order by decode(myFun(),-1,null,myFun())
执行发现排序结果不一致,查找后发现这时候decode的结果返回数据为字符型(原因未知)
外层套用to_number()解决
select *from table order by to_number(decode(myFun(),-1,null,myFun()))
myfun() return number;
select *from table order by decode(myFun(),-1,null,myFun())
外层套用to_number()解决
select *from table order by to_number(decode(myFun(),-1,null,myFun()))