Ref:http://www.adp-gmbh.ch/ora/sql/table_cast.html
create or replace type date_obj as object (dt date)
/
create or replace type date_table as table of date_obj
/
create or replace function date_range(from_dt in date, to_dt in date)
return date_table as
a_date_table date_table := date_table();
cur_dt date:=from_dt;
begin
while cur_dt <= to_dt loop
a_date_table.extend;
a_date_table(a_date_table.count) := date_obj(cur_dt);
cur_dt := cur_dt + 1;
end loop;
return a_date_table;
end date_range;
/
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
select * from table (
cast ( date_range(
to_date('01.01.2002','dd.mm.yyyy'),
to_date('31.01.2002','dd.mm.yyyy')
)
as date_table
));