Experts,

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

1- select data 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 and give me all the inserts statement day by day
so i can execute them one by one. 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