報(bào)錯(cuò)信息：ORA-01722: 無效數(shù)字問題SQL:1 2 3 4 5 6 7 8 9 10 11 | SELECT A.*,
B.FUND_CODE AS FUND_CODE,
B.FUND_FULLNAME AS Fund_Fullname
FROM BSP_SYS_ATTACH A,BSP_FUND_BASE B
WHERE A.ENTITY_ID=B.FUND_ID
|
更改后正確SQL:1 2 3 4 5 6 7 8 9 | SELECT A.*,
B.FUND_CODE AS FUND_CODE,
B.FUND_FULLNAME AS Fund_Fullname
FROM BSP_SYS_ATTACH A,BSP_FUND_BASE B
WHERE A.ENTITY_ID=TO_CHAR(B.FUND_ID)
|
拓展：將日期型轉(zhuǎn)換為字符串TO_CHAR() 1 2 3 | SELECT
TO_CHAR (SYSDATE, 'YYYY-MM-DD HH24:MI:SS AM')
FROM DUAL
|
將數(shù)字型轉(zhuǎn)換為字符串TO_CHAR() 1 2 3 | SELECT
TO_CHAR(123.45678,'$99999.999')
FROM DUAL;
|
將字符換轉(zhuǎn)換為日期TO_DATE() 1 2 3 | SELECT
TO_DATE ('20100913', 'YYYY-MM-DD')
FROM DUAL;
|
將字符串轉(zhuǎn)換為數(shù)字TO_NUMBER() 1 2 3 | SELECT
TO_NUMBER('01')
FROM DUAL;
|
|
