Re: Foreign Key Constraint ...

  • From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 6 Jan 2005 19:09:46 -0400

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@xxxxxxxxxxxxx
Date: 01/06/05 19:02:38
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: