shell中调用sqlplus
sqlplus -s user/pwd@datebase<<EOF>/dev/null
spool b.txt
select * from a;
spool off
exit
EOF
cat b.txt|tr -d ''>b.txt
shell中调用dbtool
/dxyyt/kefu/dbtool cxtyd_rw/tyd4321@gdsm2 -f[$sqldir] afljk 1>/dev/null 2>&1
dbtool user/password@usid sql="${proc01};${proc02};${proc03};" dbtool_password>>/dev/null 2>&1
sqlplus dbtool自动登录脚本
最新推荐文章于 2023-09-15 23:33:41 发布