SQL Developer import data change column datatype from varchar to integer
975581Nov 22 2012 — edited Nov 22 2012Dear all,
Can anyone know, how to change all columns datatype using one click? I want to import a csv that has more then 200 columns. When I use SQL Developer to impoprt this to Oracle Database, there is the option to change the columns' datatype, but it is posibble only column by column. How can I do this with only one mouse click? In the csv, there are only numbers, no alphabetic or other characters. But SQL Developer sets automaticully VarChar to all columns when import the csv. And if these columns' datatype is varChar, the data mining model produces only 10% predictive confidence. If the columns are integer (number), the confidence is over 80%. I have to use about 50 tables, and every table has more then 200 columns, so changing the columns datatype one-by-one is something inhuman ::(((((((
I saved the csv as xlsx, but when I tried to import it with SQL Developer, I choose this xlsx and SQL Developer has closed the import-windows. So I'm unable to import xlsx...
Can anyone help me?
Thank you!!!!!