2.4k questions

2.4k answers

94.2k users

11 Online Users
0 Member 11 Guest
Today Visits : 1301
Yesterday Visits : 2243
Total Visits : 2292580

Categories

Notice

Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you,

Elias Katsaniotis, MSc

Information

Viktoria Katsanioti,

Kaliningrad,

Russia,

matizegr@yahoo.com

0 votes
57 views

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?
in General by (95.0k points)

1 Answer

0 votes

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

by (95.0k points)
...