Re: Oracle and Foreign Key


"DA Morgan" <damorgan@xxxxxxxxx> a écrit dans le message de news: 1166389155.131891@xxxxxxxxxxxxxxxxxxxxxxxxx
| 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@xxxxxxxxxxxxxxxx
| (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


.