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!

Update Vs Delete + Insert

alexliznJan 5 2005 — edited Jan 9 2005

Hi, folks,
I'm thinking about a questions.

Suppose that we don't have foreign keys defined out there between my tables. in order to update a row in a table, we can use "UPDATE" statement as everybody knows, or we can also come up with a alternative of DELETE the row first and INSERT a new row.

What's the difference?

If it's in a huge OLTP system, what are the impacts on Oracle? any idea?

Thanks in advance!
eilison
eilisonl@yahoo.com

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2005

Added on Jan 5 2005

10 comments

8,857 views