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

Home -> Community -> Usenet -> c.d.o.tools -> Oracle support for cascade update?

Oracle support for cascade update?

From: Jeffery Cann <jccann_at_catholic.org>
Date: 2000/08/08
Message-ID: <8mpeeo$76h$1@nnrp1.deja.com>#1/1

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. Received on Tue Aug 08 2000 - 00:00:00 CDT

Original text of this message

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