dump 解決問題

使用外部表搞了一些資料到資料庫中去，結果有一列原本可以轉化為number的卻出現了ORA-01722: invalid number。

trim了半天也沒有效果，想起dump：

select">SQL>select dump(id) from test_re_2 where rownum<10;

DUMP(ID)
------------------------------------------------------------------------------------------------------------------------------------------------------
Typ=1 Len=11: 9,49,48,48,48,48,50,50,52,54,9
Typ=1 Len=11: 9,49,48,48,48,48,50,50,52,55,9
Typ=1 Len=11: 9,49,48,48,48,48,50,50,52,56,9
Typ=1 Len=11: 9,49,48,48,48,48,50,50,52,57,9
Typ=1 Len=11: 9,49,48,48,48,48,50,50,53,48,9
Typ=1 Len=11: 9,49,48,48,48,48,50,50,53,49,9
Typ=1 Len=11: 9,49,48,48,48,48,50,50,53,50,9
Typ=1 Len=11: 9,49,48,48,48,48,50,50,53,51,9
Typ=1 Len=11: 9,49,48,48,48,48,50,50,53,52,9

9 rows selected.

竟然前後各有一個製表符（9是製表符）。

replace掉，ok。

[@more@]