SQL loader

Hi list,

LOAD DATA
INFILE 'c:\temp\file2.csv'
APPEND
INTO TABLE dc_temp1
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(

name, old_po_box, dn, gsm, nregc,
cr_no, new_po_box , remark, ncli)

The above is my control file for loading data.

i need to refer the two columns of data from the datafile 'c:\temp\file2.csv'
should go into one column(remark) of my table.

Oracle7.3.1. Any ideas pls.

Thanks.
Nirmal.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  INET: NIRMALK_at_qtel.com.qa

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).