Oracleshell calls SQL to operate the database

Source: Internet
Author: User
You can use sqlplus to connect to an Oracle database and then use the database interactively. Another non-interactive method is to directly execute SQL commands through shell.

You can use sqlplus to connect to an Oracle database and then use the database interactively. Another non-interactive method is to directly execute SQL commands through shell.

You can use sqlplus to connect to an Oracle database and then use the database interactively. Another non-interactive method is to directly execute SQL commands through shell, which can be directly executed on the shell CLI port or through shell script. In terms of SQL command input, this non-interactive mode can be divided into two types: command line direct input and SQL file input.

1. direct command line Input


This method directly transmits the command to sqlplus, and-S refers to the silent mode. Note the backslash escape here.

Use the script as follows. Pay attention to the backslash.

2. input files


In this way, the SQL statement is first stored in a file, and the backslash is not required, and the input file must be suffixed with. SQL.

In this way, you can also write a shell script.

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.