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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle and Foreign Key

Re: Oracle and Foreign Key

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 18 Dec 2006 07:29:23 +0100
Message-ID: <45863542$0$11585$426a34cc@news.free.fr>

"DA Morgan" <damorgan_at_psoug.org> a écrit dans le message de news: 1166389155.131891_at_bubbleator.drizzle.com...
| Mariano wrote:
| >> --------------------------------
| >>
| >> Checking that the constraint is still satisfied.
| >>
| >> Regards
| >> Michel Cadot
| >
| > What constraint I have to check?
|
| If I understand what you are asking, and I'm not sure,
| you will need to write a trigger to accomplish what Oracle's
| referential constraint code will not.
| --
| Daniel A. Morgan
| University of Washington
| damorgan_at_x.washington.edu
| (replace x with u to respond)
| Puget Sound Oracle Users Group
| www.psoug.org

And Tom Kyte covered the subject in an article you'll find at: http://asktom.oracle.com/tkyte/update_cascade/index.html

Regards
Michel Cadot Received on Mon Dec 18 2006 - 00:29:23 CST

Original text of this message

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