SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ignoring dup_val_on_index during insert

564195Sep 4 2007 — edited Sep 6 2007

Hello!

I import data from an external table, into my main table. The data I have to insert might contain duplicates and will cause a dup_val_on_index to occur and those I just want to ignore.

How can I write my plsql to make sure the insert continues in case of a dup_val_on_index?

Best regards
Dannie

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2007

Added on Sep 4 2007

21 comments

9,005 views