ENUM in Oracle

monty10 · #1 (**permalink**) 05-05-04, 13:50

How can enumeration be achieved in Oracle eg like:-

gender enum('male','female')

in SQL.

Thanks in Advance

Nocopy · #2 (**permalink**) 05-05-04, 14:00

decode(gender,'male','1','female,'2',null)

monty10 · #3 (**permalink**) 05-06-04, 04:35

This doesn't seem to work. Although i am using objects this may be why.

Nocopy · #4 (**permalink**) 05-06-04, 13:02

Quote:

Originally Posted by monty10

This doesn't seem to work. Although i am using objects this may be why.

How do you think objects make difference?

Post code fragment.