SQL-LOADER : loade data in a specific column

jeromestettler · #1 (**permalink**) 03-20-03, 11:35

Hello,

I am a beginner with SQL*Loader. I want to load a datafile with values only for one specific column. The destination table has 189 columns. The column 1 is the target (COL1). What I have to modify in the following control file ?

LOAD DATA
INFILE 'c:\test2.txt'
APPEND
INTO TABLE TEST_TABLE
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( COL1
)

the datafile :

12234
12345
12346
12347

(sorry, my english is poor :-) )
regards
Jerome

andrewst · #2 (**permalink**) 03-20-03, 12:53

It depends on what you want/need to put in the other 188 columns:
- if they can be NULL you can omit them (they will be set to NULL)
- if they are NOT NULL but have a DEFAULT you can omit them (they will be set to the DEFAULT)
- if they are NOT NULL and do not have a DEFAULT then you must specify a value.

In the last case, there are various options for specifying a value in the control file:

COL2 CONSTANT 'x',
COL3 RECNUM,
COL4 SYSDATE,
COL5 SEQUENCE (1)
...

See the SQL Loader Guide here for more details:

http://technet.oracle.com/docs/produ...06.htm#1008669

jeromestettler · #3 (**permalink**) 03-21-03, 05:42

Dear Andrewst,

many thanks for your help, Have a nice WE.

Jerome