The DATE column is defined as CAL_DT DATE FORMAT 'YYYY-MM-DD', the value in the csv file is somthing like xxxx,"2012-08-26",xxxx, How shoud I write the SQL statement? The default parameter marker ? will have error. What about if the column defination is CAL_DT DATE FORMAT 'YY/MM/DD'?
If the SQL assisstant could not be easy to finish this task, do you have any other options? write a program to do that?
If I have a csv file whose size is 2GB(about 11000000 rows), is it doable to use the SQL assisstant?