RE: Check Contraint Question
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <MGogala@xxxxxxxxxxxxxxxxxxxx>, <ltiu@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Dec 2004 15:06:04 -0500
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Gogala, Mladen
> Sent: Friday, December 03, 2004 2:52 PM
> To: 'ltiu@xxxxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx]=20
> Sent: Friday, December 03, 2004 2:47 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
>=20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
