记录一下: 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, 1, 2)), '0123456789', '00000000000'), '0', NULL)), NULL, TO_NUMBER(TRIM(SUBSTR(TRANS_TYPE_NAME, 1, 2)))) = SUBSTR(:TRANSACTIONS。
SEND_CC_CODE,3,2) 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, 1, 2)), '0123456789', '00000000000'), '0', NULL)), NULL, TO_NUMBER(TRIM(SUBSTR(TRANS_TYPE_NAME, 1, 2)))) IS NULL) ORDER BY TRANS_TYPE
以上是我对于这个问题的解答,希望能够帮到大家。
。