Using Sqlplus to make bat execution SQL files under Windows

Source: Internet
Author: User
Tags sqlplus

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.