Experts,

For god sake help me doing that. I am trying to insert date from table to
table depending on specific date. I want to do the following:

1- select date from 06-02-2007 day by day to 02-02-2008.
2- insert into another table day by day (one by one).

Best result i am looking for is a statement like the one below. It didn't work
actually. I have been trying for a long time. I need to supstitue sysdate in the
code withe specific date like 06-02-2007.

I want this dynamic sql to run. For god sake, help me.

select 'INSERT INTO scott.emp_test SELECT * '|| FROM scott.emp || ' WHERE
a.hiredate' ||' ' < ' || sysdate + 1 ;

Thanks,



Oracle LazyDBA home page