I have a system, and at every point on the deployment of a set of database and application, especially when you need to perform the same SQL statement, need to manually database link hundreds of times, do not know to have a tool to automatically connect to the database to perform my SQL statements

CodePudding user response:

Himself wrote a BAT file or SHELL

CodePudding user response:

Count up sqlplus tools?
If your script is fixed, up sqlplus command line can complete connection on the function of the database and then execute the script
Write a batch, call up sqlplus hundreds of times

CodePudding user response:

With the script is very simple thing, such as the need to execute SQL database login account, TNS wrote in a file, a loop is executed automatically