Re: Foreign Key Constraint ...

Er, lets all just answer the question, here:

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

And the answer is a categoric and absolute NO. As already suggested, there is most certainly a design problem lurking in here somewhere.

Oh yes, and never use triggers to enforce data model integrity unless you are hanging off a cliff with one finger and there is absolutely NO alternative..... grin!

peter
edinburgh

................

On Thu, 06 Jan 2005 14:59:56 -0800, Lyndon Tiu <ltiu_at_alumni.sfu.ca> wrote:
> 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