select injured from CATALOG_SEVERE t order by cast(injured as Integer)
解决方法: select injured from tabel t order by to_number(translate(t.injured, '0123456789.' || t.injured, '0123456789.')) desc nulls last (null值排最后)
select injured from CATALOG_SEVERE t order by cast(injured as Integer)
解决方法: select injured from tabel t order by to_number(translate(t.injured, '0123456789.' || t.injured, '0123456789.')) desc nulls last (null值排最后)