Oracle Bulk Import test Data ____oracle

Oracle Bulk Import test data One, test WinDOS method
Declare
MAXRECORDS constant int:=1000;
I int: = 1;
Begin
For I in 1..maxrecords loop
INSERT INTO Test2
(ID, name)
Values
(Test2_seq.nextval, To_char (' 9999 ' +i));
End Loop;
Dbms_output.put_line (' successful data entry. ');
Commit
End
Second, from the existing table into another form of data guide
Create or replace procedure TestProc is
Begin
For C in (select ID, name from test2) loop
INSERT INTO Test
(ID,
Name
Values
(Test_seq.nextval,
C.name);
End Loop;
End TestProc;