Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cascading deletes and ORACLE

Re: Cascading deletes and ORACLE

From: sasi <sasiNOsaSPAM_at_igcar.ernet.in.invalid>
Date: Tue, 28 Dec 1999 00:12:18 -0800
Message-ID: <29bb6a0e.fb69b779@usw-ex0110-073.remarq.com>


Using Schema Manager under Oracle Enterprise manager, you can create table and set option for cascading deletes also. Even this option can be set for already created tables also providing proper foreign key relation if you establish between concerned tables.

Further calrification contact sasi_at_igcar.ernet.in In article <848b54$5a8$1_at_hiram.io.com>, mscasey_at_fnord.io.com (Casey Claiborne) wrote:
> Hello -
> Where can one find information on how to set up
> Cascading Deletes in
> ORACLE? In other words, if I delete a parent row, all
> of the children
> associated with the parent row are deleted as well.
> I would greatly appreaciate any information on the
> subject.
> TIA
> Casey :)

Received on Tue Dec 28 1999 - 02:12:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US