SELECT TRAIN_CODE FROM WEB_BZNR WHERE (MOD(TO_NUMBER(TRAIN_CODE), 2) = 1)
应改为:
SELECT TRAIN_CODE FROM WEB_BZNR WHERE MOD(TO_NUMBER((TRAIN_CODE), 2) = 1)
括号括
错了
应改为:
SELECT TRAIN_CODE FROM WEB_BZNR WHERE MOD(TO_NUMBER((TRAIN_CODE), 2) = 1)
括号括
错了
select train_code from (SELECT TRAIN_CODE, MOD(TO_NUMBER(TRAIN_CODE), 2) AS EXPR1 FROM WEB_BZNR) where expr1 = 1
檢察本地2000SERVER服务器TRAIN_CODE字段的內容,看是否有不能轉化為number的值。
我试了一个IBM RS6000、ORACLE816;一个ES40、ORACLE815;一个笔记本2000SERVER、ORACLE816都没问题!