RE: Unique Key enforcement on a DATE Column for DAY (mm/dd/yy)
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <bnsarma@xxxxxxxxx>, "oracle_L_list" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Oct 2007 11:28:24 -0400
Function-based Unique index?
Not sure about 8i.
Igor
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
Other related posts:
