Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cascade delete
As I know is cascade a part of a reference constraint like
ALTER TABLE CHILD
ADD CONSTRAINT XXX_FK_FX FOREIGN KEY (XXX)
REFERENCES MASTER ON DELETE CASCADE;
Now you only have to delete records in your master table and every depending
child-record will be deleted also.
Regards
Nicolas Bronke
Steven schrieb in Nachricht <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.
>
Received on Tue Dec 08 1998 - 10:43:08 CST