Running a large oracle SQL script in a loop

Question

I have created a large piece of script which inserts new rows at the very end into my target table.

Script contains many select statements and interim tables.

I want to loop it to run 2000 times consecutively and can't see any alternative than pushing f5 2000 times.

Is there a Oracle SQL equivalent of wrapping the code into SAS macro and looping it 2000 times?

Answer 1

PL/SQL anonymous block is best in this situation:

BEGIN
    FOR i IN 1..2000 LOOP
        -- Insert scripts go here
    END LOOP
END;
/