col1 is char(5) where as in the ex.dat it is more than 5. correct that.fields terminated by ',' optionally by '"'
(col1 char(5),col2 char(7))
ex.dat file
009hello,cd,
010world,im,
012my,name is,
Thanks,
|
Results 1 to 10 of 15
Thread: Help plz in sql loader!!!!Threaded View
|
Click Here to Expand Forum to Full Width |