mago22 (AT) hotmail (DOT) com (maria granholm) wrote


To display data for an hour for which you do not have data.. I suggest
a fixed table called HOUR, that is populated with 24 rows - one for
each hour.

You can then outer join your stats table to this hour table and output
data for hours where there are no alarms.

You can also expand this table to a TIME table that contains a row for
every second of the day. Same principle applies, but allows you a much
finer grain than a HOUR table.

Look at the GROUP BY and ROLLUP clauses in the SQL Reference Manual.
There are examples given too (in your case you will do something like
a "group by rollup(hour)" as the aggregation clause for your query).


--
Billy

"Sybrand Bakker" <gooiditweg (AT) sybrandb (DOT) demon.nl> wrote

< snip >

Your last remark is both off-topic and has a nasty racist tone. You had
better stick to what you're good at: Oracle technicalities.

met vriendelijke groeten

rob van lopik


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.501 / Virus Database: 299 - Release Date: 16-7-2003