Oracle shell脚本执行SQL语句

小知识,记录一下。

https://www.cndba.cn/hbhe0316/article/4971
https://www.cndba.cn/hbhe0316/article/4971
https://www.cndba.cn/hbhe0316/article/4971
https://www.cndba.cn/hbhe0316/article/4971
https://www.cndba.cn/hbhe0316/article/4971
https://www.cndba.cn/hbhe0316/article/4971
https://www.cndba.cn/hbhe0316/article/4971
https://www.cndba.cn/hbhe0316/article/4971
https://www.cndba.cn/hbhe0316/article/4971 https://www.cndba.cn/hbhe0316/article/4971
sqlplus -S "/as sysdba" <<EOF
set head off
set feedback off
set time off
set timing off
set echo off
select count(1) from hbhe.t1;
exit
EOF
}

版权声明:本文为博主原创文章,未经博主允许不得转载。

oracle,linux


版权声明:本文为hbhe0316原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。