Re: Referential integrity and Triggers ??

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 05 Jul 1999 13:10:16 GMT
Message-ID: <3783ae98.4668052@newshost.us.oracle.com>

A copy of this was sent to Charles McDonald <cmcdon12_at_ford.com> (if that email address didn't require changing) On Mon, 05 Jul 1999 12:13:40 +0100, you wrote:

>Hello All
>
>If a set of tables in Oracle 7.3.x are defined with a foreign key
>constraint, will those constraints be enforced without the need for
>triggers or will triggers need to be created.
>

no triggers needed.

>Specifically, if a parent is deleted will the children be deleted
>automaticaly (pending cascade delete).
>Will children only be added if a parent exists?
>

yes

>Cheers
> Charles

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jul 05 1999 - 08:10:16 CDT