Morning you all,
I wonder if I could know which record is the one that is causing the dup_val_on_index error. Let's say the following:
begin
insert .... select * from table1;
exception
when dup_val_on_index then
dbms_output.put_line('ERROR '|| SQLCODE ||' -- '|| SQLERRM);
-- Is there a way to write which ones are the duplicated records, having an insert select right here?
end;
Is there a way to DBMS_xxxxx.any_function to take out that?
Thanks in advance.