It's not clear exactly what you are trying to do, but I think an example is in order:
Code:SQL> create table xyz (x date); Table created. 1 declare 2 i integer; 3 begin 4 for i in 1..10 loop 5 insert into xyz values (sysdate+i); 6 end loop; 7 commit work; 8* end; SQL> / PL/SQL procedure successfully completed. SQL> select * from xyz; X --------- 18-OCT-01 19-OCT-01 20-OCT-01 21-OCT-01 22-OCT-01 23-OCT-01 24-OCT-01 25-OCT-01 26-OCT-01 27-OCT-01 10 rows selected. SQL>




Reply With Quote