table design structure
From: <doug.fulton_at_gmail.com>
Date: 16 Dec 2005 07:01:29 -0800
Message-ID: <1134745289.403813.324450_at_g47g2000cwa.googlegroups.com>
(i am not a developer so excuse me if this obvious)
Date: 16 Dec 2005 07:01:29 -0800
Message-ID: <1134745289.403813.324450_at_g47g2000cwa.googlegroups.com>
(i am not a developer so excuse me if this obvious)
<foriegn_key> ,<data1>, <data2>, (<data3>, <data4>)
(<data3>, <data4>)
(<data3>, <data4>)
<foriegn_key> ,<data1>, <data2>, (<data3>, <data4>)
(<data3>, <data4>)
ie the amount of (<data3>, <data4>) can be anywhere between 2 and 30. most of the reports etc will be generte from the data 3 column.
what i am trying to figure is how to store these dataforms.
i am have some exposure to oracle and i think a nested table per foriegn_key or varrays are to possible solutions but what i should use
cheers
Nug Received on Fri Dec 16 2005 - 16:01:29 CET