Err, thats 11 dates assuming you want both dates supplied.

select 

to_date('10-jun-2008','dd-mon-yyyy')+(rownum - 1)

from all_objects where rownum <= 

( to_date('20-jun-2008','dd-mon-yyyy') - to_date('10-jun-2008','dd-mon-yyyy'))+1

one way:

SQL> with t as (
  2  select to_date('10-jun-2008') min_date, to_date('20-jun-2008') max_date from dual)
  3  --
  4  select min_date+ rn from (
  5  select rownum rn from user_objects,t where rownum<=max_date-min_date),t;
 
MIN_DATE+
---------
11-JUN-08
12-JUN-08
13-JUN-08
14-JUN-08
15-JUN-08
16-JUN-08
17-JUN-08
18-JUN-08
19-JUN-08
20-JUN-08
 
10 rows selected.
 

But it is limited to the maximum number of rows in the user_objects view.

You can read about it:

http://www.oracle.com/pls/db102/homepage?remark=tahiti

(The search field is very handy)

all_objects is a view in the oracle data dictionary.

The view contains details of all objects that you have access to, whether or not you own them, 1 entry per object.
It is preferable to use all_objects rather than user_objects as user_objects only contains the objects which you own.

example: in my test schema user_objects contains 240 rows
all_objects contains 58,750 rows.

so if you use user_objects here you will never get more than 240 rows with my query on my database.

If you use all_objects, then you will never get more than 58,750 rows on my database

Try using dual with the same parameters and see what happens.

for each row returned, a day is added. If a row is not returned no more days will be added.

Any table can be used but it must have the number of days in your date_range.
all_objects will usually be sufficient, in this case.

rownum is just an internal counter that Oracle keeps. You should consider looking in the documentation: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/pseudocolumns009.htm#SQLRF00255

The query is using it to work out what to add on to the base date (eg. 10th June) in order to generate the dates.

Eg. 10th June + 0 = 10th June
10th June + 1 = 11th June
...
10th June + 10 = 20th June

Message was edited by:
Boneist for clarity

No, rownum is nothing to do with all_objects.

rownum is a pseudovariable which increments by 1 for every row retrieved. It doesn't exist in any table or view.

It is being used to add 1 day to the date for each row that is returned.
Thats why you need to have at least the number of rows that match your number of days. your result will be incorrect if this is not the case