Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQLLoader question- comma delineated data
I am loading comma separated records from a file using SQLLoader. There is more data per record than I want to store. How do I skip a field? For example, my table has 3 fields, A, B, and C. My data is 1,2,9,3. I want to load 1 into A, 2 into B, and 3 into C and skip 9 entirely. What can I put in a control file like the following to skip the third field?
OPTIONS (ERRORS=9999)
LOAD DATA
APPEND
INTO TABLE cdb_data
(
A CHAR(20) TERMINATED BY ',', B CHAR(20) TERMINATED BY ',', ????? CHAR(20) TERMINATED BY ',', C CHAR(20) TERMINATED BY ',')
Peter Koenig
koenig_at_interaccess.com
Received on Sun Mar 22 1998 - 00:00:00 CST