Skip to Main Content

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!

Execute insert statement with primary key violation

abdujaparovSep 23 2009 — edited Sep 23 2009
Hi,
I've a lot of insert statements I have to insert.
Some of these statements violete the primary key. The statements haven't got an order. How can I do to insert all the statements that not violated the constrant (and leaving out the ones violate the constraint)?
Actually when there is a statement violate the constraint the operation are blocked.
How can I solve?
Thanks, bye bye.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2009
Added on Sep 23 2009
7 comments
903 views