Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cascade delete
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