Is there a work-around to implement enum types?

Hi,

[Quoted] Is there a solution for ORACLE to implement an enum types?

i.e.

create table enum_table
(

     enum_id   number(3),
     enum_text char(10),
     primary key ( enum_id )

create table other_table
(

     some_field  char(10),
     enum_id   number(3)

create view new_view

    some_field,
    enum_text
as select some_field, enum_text
from other_table, enum_table
where other_field.enum_id = enum_table.enum_id ;

I would like to be do the following:

select some_field, enum_text from new_view ;

'field1', 'enum_text1'

and also

insert into new_view
( some_field, enum_text )

values ( 'new field 2', 'enum text1' );

Thanks in Advance,

-Willy Received on Mon May 01 2000 - 00:00:00 CEST