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: Cascade delete

Re: Cascade delete

From: victor <victor_at_PERCOMBANK.KIEV.UA>
Date: 8 Dec 1998 11:22:10 GMT
Message-ID: <01be229d$17f98170$6b14abcc@victor>

Steven <koh_cc_at_pacific.net.sg> wrote in article <366DCF51.56F0AF7C_at_pacific.net.sg>...
> hi,
>
> Can anyone advise on how to delete the master and detail table using
>
> "Cascade" SQL command.
>
> Table a : Parent table
> Table b : Child table
>
>
>
> l've tried : delete from a where a_id=1 cascade.

when create foreing key create it with "on delete cascade" clause and when delete from a where a_id=1 its will automaticc delete from b Received on Tue Dec 08 1998 - 05:22:10 CST

Original text of this message

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