sqlplus dbtool自动登录脚本

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