I have a .csv file that contains data for only certain columns in a table. How do I import that .csv into the table leaving the other columns intact (or setting the NULL value)?
Initially the table had the same columns as the .csv file and I was using this SQL loader:
INTO TABLE MY_TABLE
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
There is nothing you need to do.
Only the column values from the file will be sent.
The other columns will get their default value (typically NULL, but that depends on the column definition) when the rows are inserted.
Not sure what you mean with leaving the other columns intact, as SQL*Loader will only insert new rows, there is nothing to be "left intact".