Message-ID: <3D45BDF7.50604@me.com> Date: Mon, 29 Jul 2002 18:13:11 -0400 From: internetmaster User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.9) Gecko/20020513 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Another Referential Integrity Question Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 65.188.106.197 X-Trace: nopics.sjc 1027980800 65.188.106.197 (29 Jul 2002 15:13:20 -0700) Lines: 11 Path: news.easynews.com!easynews!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!TELOCITY!nopics.sjc!not-for-mail Xref: easynews comp.databases.oracle.server:156232 X-Received-Date: Mon, 29 Jul 2002 15:10:32 MST (news.easynews.com) Since Oracle doesn't offer Update cascade in declarative RI, doesn't it stand to reason that Triggers will be necessary to enforce this requirement? Are there any databases that allow all the anomalies to be expressed via declarative RI? Or is Oracle ahead of other databases. I'm rather interested in this subject (as you can tell by my numerous posts). Thanks for your comments.