RE: Foreign Key Constraint ...

  • From: "Lex de Haan" <>
  • 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
maybe there is room for improvement in the underlying data model...

Tom Kyte Seminar:

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


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?


Lyndon Tiu


Other related posts: