Using Sqlplus to make bat execution SQL files under Windows

If you put the required SQL operation information into a SQL file,

Need to make a bat file to execute this SQL file, then your bat file, the information after the Sqlplus login statement cannot be wrapped, newline, after the execution of the login Sqlplus will no longer run the following command.
For example, execute a SQL file under the C-Packing directory: A.sql, your batch should be written like this:
Sqlplus Username/[email protected] @c://a.sql
Of course, don't forget to join at the end of the A.sql: Quit command.

Test.bat file:

Username: User name of the login database

Password: password to log in to the database

Instancenname: DB instance address "such as 127.0.0.1/ORCL"

Sqlplus Username/[email protected] @c://test. sql

Test.sql File:

Select * from    where t.id='123'

Using Sqlplus to make bat execution SQL files under Windows