Re: Enum types

From: <catherine_devlin_at_purpleturtle.com>
Date: 14 Aug 2001 15:52:27 GMT
Message-ID: <9lbhfr$2mj$1@news.netmar.com>

In article <909653536.997788705779.JavaMail.usenet_at_eresmas.com>, buffy <buffy_at_hotmail.com> writes:
>How can I implement enum types in Oracle?
>

You might want to use a check constraint.

create table TURTLE (
species VARCHAR2(20) CHECK (species IN

                            'Box', 'Snapping', 'Western Pond')

);

Catherine Devlin http://profiles.yahoo.com/arcticturtle
- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net

Received on Tue Aug 14 2001 - 10:52:27 CDT