Foreign key to subset of records

May be it is a question, may be suggestion to Oracle. I want to create foreign key like this:

alter table <table1> add
  constraint <constraint> foreign key (<field1>,<constant>)     references <master-table> (<field2>,<field3>);

Oracle must execute SQL like

  select ... from <master-table>
    where <field2>=:param1 and <field3>=<constant>

on inserting or updating value of <table1>.<field1>

In this case primary (or unique) key on <master-table> can be (<field2>,<field3>) or (<field2>).

May be such option already exists in newest versions like 8.1.6 or 8.1.7? Thank you Received on Sun Apr 15 2001 - 13:02:04 CDT