Hello Nirmal,
The FILLER command is available in sqlloader to allow you to miss a field
out
something like
LOAD
(field 1 ...
field2 ...
dum_rec FILLER,
field3
)
may work but I am not sure that this will work in 7.3 of Oracle as I think
FILLER came out in 8.0x
However an easy way ( I was going to say the easiest but I figured someone
would send in a 1 character script to achieve the same thing)
is to use awk to concatanate the fields as in the following example
cat j.txt
aaaaa bbbb ccc dddd
cat j.txt | awk '{print $1,$2 $3,$4 }'
aaaaa bbbbccc dddd
I think that gives you what you want and you just use your loader routine
to load the amended data
HTH
John
-----Original Message-----
Sent: 10 November 2002 07:33
To: Multiple recipients of list ORACLE-L
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
