Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How enforce on update cascade ?

Re: How enforce on update cascade ?

From: Jarek Palka <triss_at_zeus.polsl.gliwice.pl>
Date: Mon, 22 Jun 1998 15:58:36 +0200
Message-ID: <6mlnsk$kau@router.kamsoft.com.pl>


>alter table <table>
> drop constraint <fk>
>
>alter table <table>
> add constraint <fk> foreign key (<col>)
> references <table> (<col>) on update cascade on delete cascade

ON UPDATE CASCADE ?
I haven't seen version of Oracle witch support such feature. Nor Oracle 7.3 nor 8.3 hasn't such clause.

Jarek Palka
P.I. Kamsoft
Katowice, Poland Received on Mon Jun 22 1998 - 08:58:36 CDT

Original text of this message

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