Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> CHECK Constraints
Hi ORAPERTS (ORAcle xPERTS)
How can I define a CHECK CONSTRAINT on a table for a field like zip code....?
Here is what I am doing:
create table test
(
state varchar2(5) check (state
in('AL','AK','AZ','AR','CA','CO','CT','DE'))
)
but it seems that it freaks out....wonder why...? I tried using DOUBLE QUOTES also but in vain....what is a correct way?
THANKS! Received on Fri Sep 05 2003 - 16:19:28 CDT