Validation of foreign keys

From: Mike Blake <blakemj_at_my-deja.com>
Date: 2000/05/04
Message-ID: <8es6j9$679$1@nnrp1.deja.com>#1/1

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. Received on Thu May 04 2000 - 00:00:00 CDT