SQL lOADER(DATA FORMAT)
Posted on 2006-10-30
My data file records looks like this
95938,95940,12-23-2005,01-26-2006,"Landmark VI CDO, Ltd.",Asset-Backed Securities,CDO,,,,310,6,B,15000000,,9.2,Aa2,AA,,Floating,,100.000,,50.000,,Libor,,Other Tranche Comments,Comments
How can I load this file using sql loader
I created the ctl file like this
INTO TABLE TT
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
It ingnore all the records
saying ORA-01008: not all variables bound
I think it is due to (") data have in ,"Landmark VI CDO, Ltd." How can I solve this problem.