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 ));