SQL Developer - mapping column names for csv import
626608Jul 17 2008 — edited Jul 21 2008In Apex I can do a spreadsheet upload to an existing table and it asks me to map source data to existing table, and it usually has the columns correct. I don't know if it imports them in order or what(first column name in table maps to first column in csv file, etc). SQL Developer makes me choose the mappings myself - it doesn't attempt to do a mapping at all, and some of my fieldnames are exactly the same. Am I missing something? Is there a way to get SQL Developer to try to do the mapping for me?
Note: in apex and sql dev, you should use csv only... they let you choose xls, but xls fails in both products every time.