Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How do I perform a delete cascade in Oracle?
hey thanks, I went ahead a used trigger to do this......... which way do you think is better?
PaulW
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:965930005.4960.0.pluto.d4ee154e_at_news.demon.nl...
> You need to define your foreign key likes this
>
> alter table emp add constraint fk_dept foreign key(deptno)
> references dept on delete cascade.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "Paul Widner" <pwidner_at_imagetag.com> wrote in message
> news:uCBk5.310$Hu4.104827_at_news.uswest.net...
> > I've found info that say oracle can do delete cascade bit NOTHING say
how
to
> > do it........ please help.
> >
> >
> > Thanks,
> > PaulW
> >
> >
>
>
Received on Thu Aug 10 2000 - 00:00:00 CDT