SQL> create table date1 (d date); Table created. SQL> insert into date1(d) select sysdate+level from dual connect by level<=10; 10 rows created. SQL> select * from date1; D --------- 06-DEC-06 07-DEC-06 08-DEC-06 09-DEC-06 10-DEC-06 11-DEC-06 12-DEC-06 13-DEC-06 14-DEC-06 15-DEC-06 10 rows selected. SQL>