I have a csv file containing NULL columns.
I need to load the data to the table for which all the columns are defined with NOT NULL constraint.
Since i have bulk data to load, it is not possible to fill the null columns with zeros or spaces. Is there any way to load the csv file without modifying the csv file and table defintion.?
I am using SQL loader for this purpose. Please let me know if there is a way change the control file to get the desired results.