Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: table constraint
"Using which function? "
Thats a very good question!! -
Thought it may be possible using something along the lines of a unique key on 2 columns plus:
TRUNC(t)||'-' || CEIL( ( ( TO_CHAR(t,'HH24') * 60 + TO_CHAR(t,'MI') ) + 1 ) /6 )
But there are bugs with that solution (can't devote any more time on it at the minute) - there may be some mathematics genius out there who enjoy a challenge!! Received on Mon Jun 25 2007 - 08:35:40 CDT