Oracleshell calls SQL to operate the database

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.