Re: Oracle and Foreign Key
- From: "Mariano" <mariano.calandra@xxxxxxxxx>
- Date: 18 Dec 2006 00:34:01 -0800
Thank You All
On 18 Dic, 07:29, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
"DA Morgan" <damor...@xxxxxxxxx> a écrit dans le message de news: 1166389155.131...@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
| damor...@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
.
- References:
- Oracle and Foreign Key
- From: Mariano
- Re: Oracle and Foreign Key
- From: Michel Cadot
- Re: Oracle and Foreign Key
- From: Mariano
- Re: Oracle and Foreign Key
- From: Michel Cadot
- Re: Oracle and Foreign Key
- From: Mariano
- Re: Oracle and Foreign Key
- From: DA Morgan
- Re: Oracle and Foreign Key
- From: Michel Cadot
- Oracle and Foreign Key
- Prev by Date: Rman - could not restore database after restoring backup controlfile
- Next by Date: Re: Rman - could not restore database after restoring backup controlfile
- Previous by thread: Re: Oracle and Foreign Key
- Next by thread: Files not found in Oracle 9iAS
- Index(es):