Re: Enumeration Types
From: <catherine_devlin_at_purpleturtle.com>
Date: 18 Apr 2001 14:21:20 GMT
Message-ID: <9bk7t0$gr4$1_at_news.netmar.com>
Date: 18 Apr 2001 14:21:20 GMT
Message-ID: <9bk7t0$gr4$1_at_news.netmar.com>
I think a check constraint would accomplish what you want. Something like
create table turtle
( type VARCHAR2(20) CHECK (type IN ('Box', 'Snapping', 'Western Pond'))
);
- Catherine
<<< snip>>>
>I am trying 2 create an enumeration type which will mean that the users can
>only select an entry which is in that type! I have tried many different ways
>of doing this, but none of them have worked! I have searched the web
>endlessly! Even the oracle website doesn't have anything (that I could find
>at least!)
<<< snip>>>
- 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