PL/SQL (MOSC)

MOSC Banner

simple test using PL/SQL procedure

edited Mar 22, 2014 12:00PM in PL/SQL (MOSC) 6 commentsAnswered

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center