suppose i've got a table named para_tab with two columns namely from_dt date ,to_dt date.
The table contains only one row with values such as
from dt='01-mar-2000' and to_dt ='31-mar-2000' .
I want to insert dummy rows starting from the from_dt and ending with the to_dt into the same table with an sql statement using the same table.
for eg:
the difference of the above mentioned dates is 31 days.
so i want to insert 31 rows into the same table with an sql
statement without using any other table.
This should be done only with and sql statement,
and only one table which contains only one row.