Re: One to One Relationship

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Mon, 17 Mar 2003 08:44:08 -0800
Message-ID: <3E75FB57.28F7E5B0@exxesolutions.com>

Wayne Hinch wrote:

> Hi,
>
> How can a one to one relationship between two tables be created in Oracle
> 9i?
>
> Any help will be much appricated.
>
> Wayne

By ignoring the rules of normalization and deciding to turn a relational database into an electronic version of a bunch of 3x5 cards.

You can do it with constraints. You can do it with triggers. And you can decide to be smart and not do it at all. Get a book on relational database theory and normalization and read it.

Daniel Morgan Received on Mon Mar 17 2003 - 10:44:08 CST