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