How to enforce one-to-one relationship in Oracle
Posted on 2004-09-16
When using a data modeling tool like ERWin I can indicate a one-to-one relationship, but is there a way I can specify (in terms of SQL statement), that through a database constraint (referential integrity etc).
I understand that one-to-one usually ends up being just one table, but the scenario I've does warrant a separate table.
Any responses will be greatly appreciated. Thanks in advance.