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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Foreign Key Constraint ...

Re: Foreign Key Constraint ...

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Thu, 6 Jan 2005 19:09:46 -0400
Message-Id: <41DDC53A.00000D.01384@JREYES>


Hi, Use a trigger  

Juan Carlos Reyes Pacheco    

Oracle Certified Professional 9i,10g ( Experience in Oracle Database 7,8i too)
Developer Certified Professional 6i
8 years of experience in developing, administrating database and designing  

-------Original Message-------
 

From: ltiu_at_alumni.sfu.ca
Date: 01/06/05 19:02:38
To: oracle-l_at_freelists.org
Subject: Foreign Key Constraint ...  

Hello,  

Can we have a foreign key column in tableB that points to a primary key in tableA, but the foreign key is only enforced if the foreign key value is greater than 1000?  

Thanks.  

--

Lyndon Tiu
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 06 2005 - 17:04:49 CST

Original text of this message

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