duplicate key insert

Question

When inserting into a table using a select from another table and creating an error with a duplicate key, is it possible to find the value of the key that was duplicated?

Answer 1

better to use a loop like

START THE LOOP:

• read the record
• check if key exists
• if not insert
• if yes write to table PROBLEMATIC_RECS
• IS THIS LAST RECORD IF YES EXIT

GO TO START THE LOOP

Do something like this with PL/SQL or PHP or PRO*C