Re: Object Relational newbie

You won't be doing it in version 7.4.3 because no such version exists. And assuming a mild case of dyslexia ... you won't be doing it in 7.3.4 either. Get yourself to 8i or 9i. <g>

Daniel Morgan

Steffen Pelzetter wrote:

> Hello,
>
> I've a question about the Oracle Object Relational Modell, I worked on
> version 7.4.3 and now I try to implement some Objects- Tables.
> As I develop in C++ it is not to heavy to me to understanmd this modell, but
> there is one thing I'm not sure if it's possible with Oracle Server (9i).
>
> The problem is this:
> For example:
>
> I've a product- table:
>
> Product ProductName ProductType
> XYZ Namexyz X-Type
>
> Every Product has various properties. But the properties are depending on
> the Product- Type.
> For example Product type X has 10 Properties, Proudcttype Y has 5
> properties.
>
> My Idear is to do something like this.
>
> Prodtype_X_Propertes
> {
> Property 1 int;
> property 2 varchar(2);
> .
> .
> .
> }
>
> Prodtype_Y_Propertes
> {
> Property 1 float;
> property 2 number(5,2);
> .
> .
> .
> }
>
> And in the Producttable I want to have a reference dependig on the product-
> type. (Should be like a void pointer)
>
> Product ProductName ProductType Property
> XYZ Namexyz X-Type Ref_to_Prodtype_X_Properties
> abc nameAbc Y-Type Ref_to_Propdtype_Y_Properties
>
> So my question is, if this is possible?
>
> or, how it could be solved?
>
> Thanks Steffen
Received on Mon Mar 04 2002 - 12:31:03 CST