Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Foreign Key Constraint ...
Hi Lyndon,
sorry for replying with a question, but this does not sound like a foreign
key to me :-)
what's the background of this constraint? what's the magic of this number
1000?
maybe there is room for improvement in the underlying data model...
cheers,
Lex.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Lyndon Tiu
Sent: Friday, January 07, 2005 00:00
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 Fri Jan 07 2005 - 03:16:17 CST