Shell 调用SQLPLUS

最新推荐文章于 2022-10-26 13:49:36 发布

原创最新推荐文章于 2022-10-26 13:49:36 发布 · 2.8k 阅读

0 ·

CC 4.0 BY-SA版权

博客主要围绕Shell调用SQLPLUS展开，虽未给出具体内容，但可知涉及后端开发中Shell脚本与SQL操作的结合，能实现自动化数据库操作等功能。

#!/bin/bash
export ORACLE_SID=PROD
export ORACLE_HOME=/u01/sq/ora_1/db/12.1.0.2

$ORACLE_HOME/bin/sqlplus -S "test/test" <<EOF
spool rt.log
select sysdate from dual;
PROMPT "COUNT T1 RESULT";
select count(1) from test.t1;
PROMPT "DELETE T1 RESULT"
delete from test.t1 where created_date> sysdate -6;
PROMPT "CONFIRM RECORDS"
select count(1) from test.t1;
commit;
spool off
exit;
EOF
date
echo "Delete sucess!"