Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Unique Key enforcement on a DATE Column for DAY (mm/dd/yy)

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

From: BN <bnsarma_at_gmail.com>
Date: Tue, 23 Oct 2007 10:44:31 -0400
Message-ID: <61292a9d0710230744p620e4eb8o5a0e90ecfc077814@mail.gmail.com> 





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 - 09:44:31 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US