I'm currently inserting data some columns from a CSV file into a table by using SQL loader and that data is validated and the remaining columns are filled automatically based on the inserted data. But if I have an unnecessary extra data beyond my required columns, that is inserting into the other columns of the table which is supposed to null if the data is ok after validation.
I want to take only certain columns from the CSV file and need to insert into table.. no need of any extra data from other columns in CSV file to be load. What should I do?
I'm wondering if there is any thing I need to include in this!
Options (ERRORS=100000,SKIP=1) Load data Append Into table emp Fields terminated by ',' optionally enclosed by '"' Trailing Nullcols
(Emp_id char, Dept char, Class integer, Subclass integer )