Batch Processing of a large number of SQL statements in Oracle

Sometimes a lot of SQL statement data needs to be inserted. However, PL/SQL tools are often used for a long period of time. Recently, PL/SQL tools are used frequently and are sorted out to facilitate future reference.

The code is simple:

Batch Processing:

Sqlplus USER/PASSWORD @ TESTDB @ E:/1. SQL
Press any key to continue PAUSE ......
Exit

1. SQL statement content under the e Disk:

Insert into users (...) values (...);
Insert into users (...) values (...);
Insert into users (...) values (...);
Commit;
Quit;

Just add commit and quit at the end of the. SQL file to submit data and exit the connection! In this way, data can be inserted through SQL statements.