Oracle Database Discussions

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!

Check to see whether record already exists. If not, insert - else update

450482Nov 18 2008 — edited Nov 19 2008

Hi

I am trying to insert/update in a table - however I will update in case the PK already exists and if there is some difference in the existing and the incoming record. And if record doesnt exist at all, I will insert.

What is the best way to find out whether record will be inserted/updated based on its presence?

This post has been answered by 469753 on Nov 18 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2008

Added on Nov 18 2008

#general-database-discussions

12 comments

1,721 views