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

BN,

How about just adding a unique function based index that uses a TRUNC to
take the date down to a "unique" day like so:

create table rg_test( d date );
Table created.

create unique index rg_idx on rg_test ( trunc(d) );
Index created.

insert into rg_test values( sysdate );
1 row created.

 insert into rg_test values( sysdate );
insert into rg_test values( sysdate )
*
ERROR at line 1:
ORA-00001: unique constraint (U31125.RG_IDX) violated

On 10/23/07, BN <bnsarma@xxxxxxxxx> wrote:
>
> 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
>



-- 
Rumpi Gravenstein

Other related posts: