为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8
【操作系统】：Windows
【CPU】:
【问题描述】*：在DM管理工具中可以实现根据sort排序，空值排在后面，但在java中查出来就是空值在前面 select
t.APPHOME_ID,
t.CHAPTER_CODE,
t.CHAPTER_NAME,
t.FLD_CODE,
t.FLD_NAME,
t.MXID,
t.PARENT_FLD_CODE,
t.PARENT_FLD_NAME,
t.MXID_PATIENT_ID,
t.MB_ID,
t.DELETE_FLAG,
t.XYLD_FLD_CODE,
t.XYLD_FLDINFO_CODE ,
t.ALIKE_CODE alikeCode,
(select FLDINFO_NAME from FSTAID_FLD_INFO b where b.delete_flag = '0' and b.FLD_CODE = t.XYLD_FLD_CODE and b.MBID = t.MB_ID and b.FLDINFO_CODE = t.XYLD_FLDINFO_CODE ) xyldFldinfoName,
(select SORT from FSTAID_APPHOME_ROLE s where s.apphome_id = t.apphome_id and s.department_id='460737103' ) sort,
(select DISPLAYNAME from FSTAID_APPHOME_ROLE s where s.apphome_id = t.apphome_id and s.department_id= '460737103') displayname,
(select checked from fstaid_apphome_role a where a.apphome_id = t.apphome_id and a.department_id= '460737103') checked
from fstaid_apphome_fld t
where t.delete_flag = '0' and mb_id = '103' order by TO_NUMBER(sort) asc