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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Foreign key in Oracle Sql

Re: Foreign key in Oracle Sql

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 13 Jan 2005 17:40:15 -0800
Message-ID: <1105666815.313811.17930@f14g2000cwb.googlegroups.com>


We find the ability to add a FK constraint without validation very useful. We have added unvalidated constraints to a couple of tables so that all new data has to pass the FK test while containing data retrieved from a legacy mainframe system that sometimes does not meet the tests. This has allowed up to tap into history going back over 20 years. Having online access using the current sytem without modification has proven very useful to the customer. -- Mark D Powell -- Received on Thu Jan 13 2005 - 19:40:15 CST

Original text of this message

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