vincelewin
IS-IT--Management
I have an oracle database with a Primary key.
I am importing via ODBC an XL spreadsheet which contains aditional records but there are some records that have change's that I want to update.
Now as we all know when I try to import a record with the same Primary key it will error and leave these records out. The DB is live therefore I cannot really delete things prior to importing.
How using SQL language can I import the new records and change the existing records?
I am importing via ODBC an XL spreadsheet which contains aditional records but there are some records that have change's that I want to update.
Now as we all know when I try to import a record with the same Primary key it will error and leave these records out. The DB is live therefore I cannot really delete things prior to importing.
How using SQL language can I import the new records and change the existing records?