Re: Another Referential Integrity Question

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 30 Jul 2002 11:23:28 +1000
Message-ID: <YMl19.47059$Hj3.143206@newsfeeds.bigpond.com>

Hi again Internetmaster.

No, Oracle doesn't automatically provide an Update Cascade FK option and yes, triggers is a good way to implement this in Oracle.

I know DB2 offers Update Cascade capabilities although I'm not sure how it implements this. I'm not sure why Oracle doesn't offer this (it's only recently provided the delete set null capability).

Regards

Richard
"internetmaster" <youlove_at_me.com> wrote in message news:3D45BDF7.50604_at_me.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.
>
Received on Mon Jul 29 2002 - 20:23:28 CDT