Batch Data insertion in oracle

Batch Data insertion in oracle

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