simple test using PL/SQL procedure
I need to run a simple test using PL/SQL procedure. please help....how to.
I have a huge table, doctor_info, with 6 columns, 350 million rows,
for a test I would like to do the following:
1. select 1000 rows at a time
2. insert 1000 rows into Doctor_info_new table with additional column - sysdate,
3. commit;
4. sleep for 5 minutes (execute dbms_lock.sleep(300);)
4. wake up and do above steps again until all rows are inserted.
5. exist when all rows in the original table has been completed.
Part of the procedure:
variables
v_col_a varchar2(25);
v_col_b char(1);
v_col_c varchar2(100);