Re: enforcing uniqueness across tables
Many thanks for the helpful replies.
Am I correct in thinking that Peter's reply would not prevent the database from inserting stock simultaneously into repair and customer and furthermore that this is the usual approach to this sort of situation? Hence, per Rick, I'd need to enforce this in the applications that do the CRUD work?
I can do that, but thought that it was best practice to enforce business logic in the database itself. Is that not possible in this instance?
Thank you for your patience with this beginner - Paul
Subject
Written By
Posted
Re: enforcing uniqueness across tables
July 13, 2015 10:39AM
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.