Re: Oracle and Foreign Key

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 17 Dec 2006 07:46:10 +0100
Message-ID: <4584e7b1$0$16994$426a34cc@news.free.fr>

"Mariano" <mariano.calandra_at_gmail.com> a écrit dans le message de news: 1166302005.873461.198240_at_16g2000cwy.googlegroups.com...
|> --------------------------------
| >
| > Checking that the constraint is still satisfied.
| >
| > Regards
| > Michel Cadot
|
| What constraint I have to check?
|

Sorry, I misread your previous post.
Yes, "NO ACTION" is the only and implicit "action" on UPDATE. Oracle checks that foreign key is still satisfied after the update, this is what I meant, you have nothing to do.

Regards
Michel Cadot Received on Sun Dec 17 2006 - 00:46:10 CST