Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Enforcement of 1 to many
Gurus,
I need to enforce a 1 ( mandatory ) to many relationship between 2 tables. Can the database do this or should we control it at the application level ? We do have a FK on the child table but how do we enforce ALL parents to have at least 1 child ? Procedurally ?
TIA,
Cliff
( I have 2 kids so I'm covered )
The contents of this message express only the sender's opinion. This message does not necessarily reflect the policy or views of my employer, Merck & Co., Inc. All responsibility for the statements made in this Usenet posting resides solely and completely with the sender.Received on Tue Apr 27 1999 - 08:10:52 CDT