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


I have a requirement to enforce Uniqueuness on a DATE Column for a day only

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

Other related posts: