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

Home -> Community -> Usenet -> c.d.o.server -> Re: table constraint

Re: table constraint

From: Matt T <puskas.duck_at_gmail.com>
Date: Mon, 25 Jun 2007 13:35:40 -0000
Message-ID: <1182778540.033465.239270@w5g2000hsg.googlegroups.com>


"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

Original text of this message

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