Posted on 2007-12-05
We have 10 column in the datafile and 3 column in our staging table. We need to pick the 7th column out of the data file and append into the 2nd column of the staging table using sql loader. This is what we have for syntax so far.
APPEND INTO TABLE "STAGING_TABLE"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(COLUMN_1, COLUMN_2, COLUMN_3)
This syntax seems to insert the first 3 columns from the datafile to the 3 columns in the staging tables, it won't allow us to pick the 7th column for the datafile to insert into the 2nd column in the staging table. This does not seem to work. Any help would be great