Re: Q: SQL*Plus Allowable Values?

Justin Wigg wrote:

> Can someone please tell me how to add an allowable values constraint to
> a VARCHAR2 column in SQL*Plus?

I think what you need is;

alter table tabx
add constraint flda_check
check (flda in ('A', 'B','C','etc'));

Hope this helps,

Ian Received on Thu Nov 27 1997 - 00:00:00 CET