Re: Q:check constraint question ?

From: Emmanuel HUMBLOT <e_humblot_at_wanadoo.fr>
Date: 20 Jan 2000 17:06:53 GMT
Message-ID: <01bf6371$8f80cb20$3601017e@EHM.cirra.fr>

create table yourtable (c1 number,

		         c2 number,
		       check ((c1!=1) or (c1=1 and c2=0)));

--
Regards

Emmanuel HUMBLOT e_humblot_at_wanadoo.fr

tedchyn_at_yahoo.com a écrit dans l'article <867723$41b$1_at_nnrp1.deja.com>...
> Sir, how do i create table with following constraint ?
>
> two columns(c1 number,c2 number) and check constraint is c2=0 when c1=1.
> thanks in advance
> Ted Chyn
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Thu Jan 20 2000 - 11:06:53 CST