URGENT: SQL LOADER Question: Setting multiple columns from one record in dat file

I have a table with 4 cols,
col1, col2, col3...col4

and dat file is
ABC|XYZ

Ctl file " LOAD DATA IN ................................(COL1, COL3)

Q..Can anybody suggest how to SET it so that ABC goes to both col1, col2
XYZ goes to both col3 , col4

Thanks a lot for help.
navneet Received on Wed May 24 2006 - 09:24:34 CEST