Using sqlplus to operate database in shell script

Oracle client installation steps are shown in the blog post: CSDN

shell operation database tool script: https://download.csdn.net/upload/10975286

When operating the database in the shell script, you can use sqlplus

#Set database connection string

conn=user/[email protected]:1521/SID#define sql

sqlstr="select sysdate from dual;"#Execute sql and get the result

sql_exc=$( sqlplus $conn <

$sqlstr

commit;

exit;

EOF

)#echo "sql execution result:"$sql_exc

This method can get a lot of results, in addition to sql query results, there are also many version information and many other irrelevant characters, it is difficult to get the query results

So modify it to the following code, which solves many problems of printing results, and only prints the results to be queried.

#Set database connection string

conn=user/[email protected]:1521/SID#define sql

sqlstr="select sysdate from dual;"#Execute sql and get the result

sql_exc=$( sqlplus -s /nolog <

      set echo off feedback off heading off underline off;

      conn $conn;

$sqlstr

commit;

exit;

EOF

)#echo "sql execution result:"$sql_exc