Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: table constraint
> Will your solution do this?
No sorry, I misinterpreted the question. The solution I presented makes sure that in each 3 minute interval there is only 1 record, which is different from your requirement that each entry must have a gap of at least 3 minutes (or is it 3 seconds?) from the nearest other rows.
I was thinking about solving this with a fast refreshable materialized view, but it has too many restrictions (and it would only enforce the constraint at commit time)
Two options left:
Regards,
Rob.
By the way: does anybody know how I can make my name appear instead of my email address? Received on Mon Jun 25 2007 - 11:04:42 CDT