Re: How do I perform a delete cascade in Oracle?

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