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

From:http://tw.wingwit.com/Article/program/Oracle/201311/17208.html