From oracle-l-bounce@freelists.org Fri Dec 3 14:05:03 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iB3K53b13269 for ; Fri, 3 Dec 2004 14:05:03 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iB3K4xd13262 for ; Fri, 3 Dec 2004 14:04:59 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C292572C2FC; Fri, 3 Dec 2004 15:11:02 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20382-53; Fri, 3 Dec 2004 15:11:02 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E64CD72C4D4; Fri, 3 Dec 2004 15:09:05 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: Check Contraint Question Date: Fri, 3 Dec 2004 15:06:04 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Check Contraint Question Thread-Index: AcTZch8eVSsKW5z9QZSsiz+VmKxkMwAAElMQ From: "Bobak, Mark" To: , , X-OriginalArrivalTime: 03 Dec 2004 20:06:04.0444 (UTC) FILETIME=[84B99DC0:01C4D973] X-archive-position: 13104 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-To: Mark.Bobak@il.proquest.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org > [mailto:oracle-l-bounce@freelists.org]On Behalf Of Gogala, Mladen > Sent: Friday, December 03, 2004 2:52 PM > To: 'ltiu@alumni.sfu.ca'; oracle-l@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@alumni.sfu.ca]=20 > Sent: Friday, December 03, 2004 2:47 PM > To: oracle-l@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