RE: Foreign Key Constraint ...

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 7 Jan 2005 10:17:22 +0100
Message-Id: <20050107100544.8D20FDBBE@node42.naturaljoin.nl>

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.  

---

Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html

---

 

-----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