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)",
阅读更多
换一批

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