CHECK Constraint

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 - 23:19:59 CEST