Re: ON UPDATE CASCADE - is there such a thing?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 24 Jun 2004 21:09:28 +0200
Message-ID: <40db26c4$0$29364$626a14ce@news.free.fr>

"harry" <a_at_abc.com> a écrit dans le message de news:gBCCc.1643$wJ1.15638676_at_news-text.cableinet.net...
> Using Oracle 8i
>
> Is there a statement I can use to force the update of foreign keys if the
> referenced key is changed - similar to ON DELETE CASCADE?
>
> hope this makes sense?
>
> thanks
>
> harry
>
>

There is no ON UPDATE CASCADE but have a look at Tom Kyte Update Cascade package:

http://osi.oracle.com/~tkyte/update_cascade/index.html

Regards
Michel Cadot Received on Thu Jun 24 2004 - 14:09:28 CDT