Hi All:

I need some assistance with writing a PL/SQL script.

I need to create a script that would out put the following format.
Basically I need to set a time range and count the total number of messages
within that range. The message are time tagged.

Actually it needs to be flexible in that any a user can it enter any range as
input. Such as 5 minute increments or 10 increments. But it must be for the
whole day.

0000-2359.


Any help would be appreciated. At this point I am stuck.

Here is a printout of the final product.

Begin Time End Time # of Messages
0000 0014 12
0015 0029 9
0030 0044 21
0045 0059 22
0100 0114 23
0115 0129 8
0130 0144 7
0145 0159 4
0200 0214 2
....
....
....
2330 2344 22
2345 2359 11


thanks

dlj

Oracle LazyDBA home page