RE: Check Contraint Question

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 3 Dec 2004 15:06:04 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9C29@AABO-EXCHANGE02.bos.il.pqe>

Actually, I was thinking function-based index.....

Perhaps:

create unique index weird_constraint on = weird(decode(column2,1,column1,null),decode(column2,1,1,null))

will do it.

-Mark

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Gogala, Mladen
> Sent: Friday, December 03, 2004 2:52 PM
> To: 'ltiu_at_alumni.sfu.ca'; oracle-l_at_freelists.org
> Subject: RE: Check Contraint Question

>=20
>=20

> You don't write column for that. You write a trigger.
> --
> Mladen Gogala
> Ext. 121

>=20

> -----Original Message-----
> From: Lyndon Tiu [mailto:ltiu_at_alumni.sfu.ca]=20
> Sent: Friday, December 03, 2004 2:47 PM
> To: oracle-l_at_freelists.org
> Subject: Check Contraint Question

>=20

> Hello,

>=20

> Could use some help here.

>=20

> Table1 has:

>=20

> Column1 varchar(32) is non-unique
> and
> Column2 number(1) with a constraint check (Column2 in ('0','1'))

>=20
>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 03 2004 - 14:05:03 CST