Unanswered: SQL-LOADER : loade data in a specific column
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 ?
INTO TABLE TEST_TABLE
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
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: