hali

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-0607-DEC-0608-DEC-0609-DEC-0610-DEC-0611-DEC-0612-DEC-0613-DEC-0614-DEC-0615-DEC-0610 rows selected.SQL>