ORACLESQL判断字符串是否为数字的语句

记录一下

SELECT *

FROM (SELECT TRANS_TYPE TRANS_TYPE_NAME

FROM QGIS_TRANS_TYPE

WHERE NVL(FLAG N) = Y

AND DECODE((REPLACE(TRANSLATE(TRIM(SUBSTR(TRANS_TYPE_NAME ))

)

NULL))

NULL

TO_NUMBER(TRIM(SUBSTR(TRANS_TYPE_NAME )))) = SUBSTR(:TRANSACTIONSSEND_CC_CODE)

UNION ALL

SELECT TRANS_TYPE TRANS_TYPE_NAME

FROM QGIS_TRANS_TYPE

WHERE NVL(FLAG N) = Y

AND DECODE((REPLACE(TRANSLATE(TRIM(SUBSTR(TRANS_TYPE_NAME ))

)

NULL))

NULL

TO_NUMBER(TRIM(SUBSTR(TRANS_TYPE_NAME )))) IS NULL)

ORDER BY TRANS_TYPE