RE: Check Contraint Question

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Fri, 3 Dec 2004 14:52:01 -0500
Message-ID: <D42C14B2E3F2B74DB41D5B6B2E2B992F01931F48@pegasus.lawaudit.com>

You don't write column for that. You write a trigger.
--

Mladen Gogala
Ext. 121

-----Original Message-----

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

Hello,

Could use some help here.

Table1 has:

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 03 2004 - 13:49:46 CST