Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle support for cascade update?
Jeffery Cann wrote:
>
> Greetings
>
> In Toby Teorey's 'Database Modeling and Design' (BTW - A great book), he
> shows some DDL examples for foreign keys:
>
> ...foreign key ( col ) references table
> on delete cascade
> on update cascade
>
> Oracle does not support the 'update cascade' clause. Is this clause
> part of the ANSI SQL92 standard? Why doesn't Oracle support it? Do
> other vendors support it?
>
> Thannks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
You can implement it with triggers...
See http://osi.oracle.com/~tkyte
HTH
-- =========================================== Connor McDonald http://www.oracledba.co.uk We are born naked, wet and hungry...then things get worseReceived on Tue Aug 08 2000 - 00:00:00 CDT