ORDER BY TO_NUMBER(S.STOCK_CODE) 当S.STOCK_CODE不是数字字符串时会报错的处理

"select case when S.INSTRUMENT_TYPE = 'INDX' then '0' else S.CODE end as DISPLAY_ORDER, s.*," +
....
" ORDER BY to_number(DISPLAY_ORDER)",
阅读更多
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭