Batch Data insertion in oracle

Once a function is developed, tens of thousands of pieces of data provided by others need to be imported *. there are about 80 thousand pieces of data in the SQL file: insertintotesttable (id, name) values (80 thousand) ----- more than pieces according to common habits, copy all insertinto statements directly to a new SQL window in plsql, and the result is stuck.

Once a function is developed, tens of thousands of pieces of data provided by others need to be imported *. there are about 80 thousand pieces of data in the SQL file: insert into testtable (id, name) values (1, '1') ----- more than 80 thousand pieces according to common habits, directly copy all the insert into statements to a new pl/SQL window for execution, and the results are stuck.

Once a function was developed, tens of thousands of pieces of data provided by others need to be imported,

There are about 80 thousand pieces of data in a *. SQL file.

Insert into testtable (id, name) values (1, '1') ----- more than 80 thousand

As usual, all the insert into statements are directly copied to a new SQL window in pl/SQL, and the results are stuck.

Then Open pl/SQL ---> File ---> Open ---> SQL Script and directly execute *. SQL File for import. The result remains stuck.

With the help of colleagues, I used another method to solve this problem:

Open pl/SQL ---> File ---> New ----> Command Window ---> input @, press Enter, and select the File where the data to be imported is located (generally *. SQL file) --- execution successful