Re: CHECK Constraints

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Sat, 06 Sep 2003 00:06:24 +0200
Message-ID: <r42ilvovvpr7ae6v8glo72aq6jm9krta3b@4ax.com>

On 5 Sep 2003 14:19:28 -0700, hari_om_at_hotmail.com (Hari Om) wrote:

>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!
define 'freaks out' or post the exact error message. Please don't post riddles, and don't try to be 'funny': you seem to become a real bore soon enough.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Sep 05 2003 - 17:06:24 CDT