RE: Unique Key enforcement on a DATE Column for DAY (mm/dd/yy)

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Tue, 23 Oct 2007 11:28:24 -0400
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A2024FFF04@EXCHANGE.corp.perceptron.com>

Function-based Unique index?
Not sure about 8i.

Igor

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BN Sent: Tuesday, October 23, 2007 10:45 AM To: oracle_L_list
Subject: Unique Key enforcement on a DATE Column for DAY (mm/dd/yy)

Greetings

I have a requirement to enforce Uniqueuness on a DATE Column for a day only (mm/dd/yy(yy)

Should allow users to enter data only once in a day, Can it be enforced through a Unique constraint

Need to implement this in Oralce 8i, 9i, 10g

-- 
Regards & Thanks
BN 

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

Received on Tue Oct 23 2007 - 10:28:24 CDT