Skip to Main Content
Forums

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!

Updating intersection table

pl_sequelJul 7 2010 — edited Sep 16 2010
Running Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production... (we'll be upgrading to 11g soon, but for now, stuck with 9i)

This might be SQL 101... but inquiring to see if there are better options.

I have an intersection table which implements a M-N relationship.

Whenever an update is required to the intersection table, I've always deleted affected rows first, then re-inserted new rows.

I'd like to know if there are better ways to handle this?

Thanks

Stephane
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 14 2010
Added on Jul 7 2010
5 comments
1,153 views