Bruman wrote:
> Michel Cadot wrote:>
>> Here's another query which works even if the interval
>> between 2 rows is not 10 minutes:
>>
>> select begin_time,
>> last_value(end_time)
>> over (order by begin_time
>> range between current row
>> and interval '1:59:59' hour to second following)
>> end_time,
>> sum(undoblks)
>> over (order by begin_time
>> range between current row
>> and interval '1:59:59' hour to second following)
>> undoblks
>> from v$undostat
>> order by begin_time
>> /
>>
>> Regards
>> Michel Cadot
>
> I like it. Is there a good source on Analytic Functions other than the
> Oracle documentation? Some of us dunderheads have trouble following
> the little charts and need examples to understand what is going on.
An excellent source: Michel: If we get his book published. Anyone out
there that can help him with translation into English? If so I likely
can get it into print.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Dec 07 2006 - 14:43:19 CST
