RE: Foreign Key Constraint ...
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <ltiu@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 7 Jan 2005 10:17:22 +0100
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Lyndon Tiu
Sent: Friday, January 07, 2005 00:00
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:
