Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table Design Question
I would have used Parent product.
There is a specific SQL Code which you specify how many level you want to
go down, and Oracle would do the select for you.
Tom
Sean <dolans_at_my-deja.com> wrote in message
news:8ajba7$5ic$1_at_nnrp1.deja.com...
> I am curious of the best way to approach this design. If you had
> products and then subproducts and then further subproducts, how would
> you lay out the table? Multiple? Or one table with a "Parent" product
> entry? For example : Printers:HP:4Si:Toner
>
> Thanks!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Mar 13 2000 - 22:06:47 CST