Execute SQL files in batches and output execution logs

Execute SQL files in batches and output execution logs. 1. Create the betchinsert. bat file. Content: sqlplus username/password @ service name @ BETCH. SQL> SQLINSERT. log exit 2. Create The betah. SQL file. Content: @ nkgis. SQL \ AE _USERS. SQL @ nkgis. SQL \ AE _ROLES. SQL @ nkgis. SQL \ AE _MENUS. SQL you can write multiple SQL files. Note that the path is correct. Here, nkgis. SQL is the folder name. 3. Create the corresponding SQL file, such as AE _USERS. SQL 4. Execute betchinsert. bat to execute all the SQL files. The SQLINSER. log file is generated in the same directory of the betchinsert. bat file. The system automatically exits after the execution is completed.