Re: 2 Unique FKs in single Table
Posted by: Rick James
Date: August 06, 2016 05:05PM

Probably the answer involves not having 2 sensors in the same row. Instead 2 rows, each with one sensor.

At that point UNIQUE, and other techniques, can probably catch your restrictions without using a TRIGGER.

Options: ReplyQuote


Subject
Written By
Posted
Re: 2 Unique FKs in single Table
August 06, 2016 05:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.