Re: How to Represent Enum Types and Relationships in Oracle

"David Hammond" <david_hammond_at_yahoo.com> wrote in message news:<b066ci$o5f$1_at_wotsit.aston.ac.uk>...
> Hi, I'm developing a object database in Oracle 8 but am having a few
> problems represents enumeration types and relationships.
>
> I have used the ODBMG schema for a logical model and have the following:-
>
> attribute enum credit-rating{poor,normal,good) credit-rating;
>
> and relationships of the type
>
> relationship set<order> placed by inverse order::places;
> relationship customer places inverse customer::placed by;
>
> how do I implement these in Oracle 8, there seems to be no obvious on-line
> help, which is strange?
>
> Thanks.
> David.

I dont think there is any innate functionality for this, so you have to use something else to simulate it. Examples:

1. Look up table, with 2 columns. One for the Key Number, other value
2. VARRAY stored in database. Use the index for your ENUM number

Might be able to do something with an object type. Dont know if this has been added to 9i? Received on Thu Jan 16 2003 - 09:03:16 CST