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

  • From: BN <bnsarma@xxxxxxxxx>
  • To: oracle_L_list <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 23 Oct 2007 10:44:31 -0400

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2007