Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Foriegn Key Question

Re: Foriegn Key Question

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 11 Aug 2006 21:43:44 +0200
Message-ID: <ebimd5$es5$1@news1.zwoll1.ov.home.nl>


Wally schreef:

>
> I guess Richard's idea of
>
> - Creating a separate summary table holding just the PK values and
> table

For the record: that is called an 'intersection table'. Common approach for Oracle, or any RDBMS, to implement M:M relationships.

See it as the best technically possible solution to modeling M:M relations

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Fri Aug 11 2006 - 14:43:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US