Sounds made to order for a check constraint on the column of interest.
Pat
>
> Is there any way you can specify that the only permissible values (is it
> called a domain?) that can be entered in varchar2 field in an Oracle
> table to, for example, A, B and C?
>
> We can restrict what values users can enter at the application level,
> but it would be nice to be able to also restrict what can be entered at
> the database level, in case other means of entering data are ever used
> or if the application layer fails, for whatever reason, to trap an
> unwanted value.
>
>
> Thanks
>
> --
> Aidan Whitehall <aidanwhitehall_at_fairbanks.co.uk>
> Macromedia ColdFusion Developer
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pat Hildebrand
INET: pat_at_ssc.upenn.edu
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Jan 30 2003 - 11:31:44 CST
