I have the misfortune of needing to import data that is in a .csv file into an oracle table. The table does not exist. Using SQL dev, right click on the table icon and select import data. Go through the wizard. The wizard makes failed effort of defining the field types and lengths, and produces the error shown in the image below
Question: what change is needed to get the negative number to import into the new table?
This is a perfect example of why oracle and windows together is a new agony every day.
Such a complicated problem. NOT Should not be a problem. The software should handle this without someone having to hold its hand
We have a system that outputs data into a .csv file,which always creates problems like this one.
Now that csv file needs to be imported into Oracle. What is the magic secret code to enter into this stupid form to make this error disappear and allow the negative number into the database?