Re: Validation of foreign keys

From: <marcpark_at_my-deja.com>
Date: 2000/05/04
Message-ID: <8es9dd$9oc$1@nnrp1.deja.com>#1/1

If you have constraints enabled (It has to be set up as constraint) enabled, then Oracle will check all constraints to ensure they are correct.

Marc Parkinson
Oracle Developer

In article <8es6j9$679$1_at_nnrp1.deja.com>, Mike Blake <blakemj_at_my-deja.com> wrote:
> I have been trying to find out if Oracle will validate all foreign
keys
> in a table during an update. I have a table wit a lot (37) foreign
> keys. The majority are not required. The process that exists for
> populating the table added foreign keys as the user progresses through
> the application. So, the insert of the row will have only the
required
> 3 foreign keys. When the user updates the row, will Oracle validate
> only the newly added/changed foreign keys or validate all the foreign
> keys?
>
> Any ideas?
>
> TIA
>
> Mike Blake
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu May 04 2000 - 00:00:00 CDT