Home » Uncategorized

Updating views on multiple tables

30 January 2004 1,190 Views No Comment

I think most databases are happy to update views that only involve a single table. But when you involve multiple tables, you have to provide a rule of some sort to tell the DBMS what to do when it can’t necessarily figure it out. Apparently Oracle will try to do an update on multiple tables, but the update will fail if there are issues. But as of Oracle v7.3, you can update views on multiple tables by using INSTEAD OF triggers.

Leave your response!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.