Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

zero to many relationship

977650Mar 7 2013 — edited Mar 7 2013
Hi,

I have one RDBMS concept question.

if i have 2 tables with 0 to many realtionship. can i create referential integrity constraint between them?

In other words how can i tell whether the records in table A(child table) are not orphan records and have 0 to many relationship with table B(parent table) ?

Right not there is no constraint defined on both tables.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2013
Added on Mar 7 2013
3 comments
613 views