Home -> Usenet -> comp.databases.oracle -> Modelling a M:N Relationship

Modelling a M:N Relationship

From: Colum Foley <columfoley_at_hotmail.com>
Date: Sat, 9 Nov 2002 08:55:10 -0800
Message-ID: <c6bz9.27662$zX3.69368_at_news.indigo.ie> 






Hello,


I am having great difficulty in modelling the following relationship in
Oracle and would appreciate any help.



I have a type called Product and I want to store a nested table of all
Suppliers of this product.


Also for suppliers I want to store all the products they supply. So ill have
a kind of two-way nested table.


How would I go about modelling this realtionship?
I am a begginer to Oracle ,  and would prefer a simple solution but any help
will be much appreciated.


Thanks


Colum
Received on Sat Nov 09 2002 - 17:55:10 CET












Original text of this message