yes i am mapping the columns and it is inserting whole
insert into dpcdr.CALLID ("ID" ,MOBILE_NUMBER ,OTHER_PARTY ,CALL_TYPE ,CALL_DATE_TIME ,DURATION )
into my first column
How to skip or exclude this?
It is unclear what you are trying to do.
If you are trying to run the insert statements to load the data into the dpcdr.callid table, then just START the sql file. SQL*Loader is not appropriate for this.
If you want to load the insert statements into some table, one statement for each row, all in one column, then use SQL*Loader and use the semicolon as a record terminator.