Load bulk data using Oracle Stored Procedure bulk INSERT example using loop

Oracle Stored Procedure bulk INSERT example using loop

SQL> create table t ( x int, y varchar2(500) );

Table created.

Elapsed: 00:00:00.08
SQL> begin
    for i in 1 .. 100000
    loop
        insert into t values ( i, 'xxxxxxxxxxxxx' );
    end loop;
    commit;
end;
/  2    3    4    5    6    7    8

PL/SQL procedure successfully completed.

Elapsed: 00:00:03.70
SQL>