sqlldr去掉空格
以下是数据文件data.txt的内容111 , 222 444 ,55 以下是控制文件control.ctl的内容load datainfile 'C:\Documents and Settings\ilovemk\桌面\data.txt'appendinto table testfields terminated by ','(cola "trim(:cola)",colb "trim(:colb)")SQL> ho sqlldr scott/cgb2235599 control='C:\Documents and Settings\ilovemk\桌面\control.ctl'-> data='C:\Documents and Settings\ilovemk\桌面\data.txt'SQL*Loader: Release 10.2.0.1.0 - Production on 星期日 9月 30 00:31:32 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.达到提交点 - 逻辑记录计数 12select length(cola),length(colb) from test;LENGTH(COLA) LENGTH(COLB)------------ ------------ 3 3 3 2个人觉得用varchar2字段好一点^_^
