Filling in "gaps" in data

Oracle 10g R2 10.2.0.1.0

Hi

I posted (couple of weeks ago) on this (as a sub-thread) but wanted to ask it here with some clarity.

Say we have a table with date/time related data

create table hits

(date_time		date,
 ip_address		varchar2(240));

And our data look like this:

date_time		ip_address
---------     	----------
31-oct-2008 13:08	192.168.0.1
31-oct-2008 13:08	192.168.0.1
31-oct-2008 13:11	192.168.0.1
31-oct-2008 13:12	192.168.0.1
31-oct-2008 13:15	192.168.0.1

I want to produce a report that shows the number of hits per minute but include the "gaps" where there is no data recorded.

So I would like to see:

date_time		hits
---------     	----
31-oct-2008 13:08	2
31-oct-2008 13:09	0
31-oct-2008 13:10	0
31-oct-2008 13:11	1
31-oct-2008 13:12	1
31-oct-2008 13:13	0
31-oct-2008 13:14	0
31-oct-2008 13:15	2

Is it possible without outer-joining to another table with "time" data in it?

I was previously pointed to http://download.oracle.com/docs/cd/B19306_ 01/server.102/b14223/analys... which relates to data densification - but this method involves getting the "blanks" from another table.

-- 
jeremy