Re: Cascade Deleting

From: Frank <fbortel_at_home.nl>
Date: Sun, 01 Dec 2002 12:42:10 +0100
Message-ID: <3DE9F592.2090606@home.nl>

Nikola Letic wrote:
> Hallo,
> is there an automatic way to cascade delete records from tables using
> (foreign key) referential integrity constraints without programming for
> every case or manually defining triggers. Eg. if i delete customer from
> customers table i want oracle to delete customers orders also from orders
> table to preserve integrity.
>
>

check out the Foreign Key statement: on delete cascade is fully supported.

Grtz, Frank Received on Sun Dec 01 2002 - 05:42:10 CST