登陆oracle并取值
VALUE=`sqlplus -s abc/abc123@ora<<EOF
set heading off;set feedback off;
set pagesize 0;
set verify off;
set echo off;
select count(*) from tab_abc where acct_month='${LASTMONTH}';
exit;
EOF`
登陆oracle 进行数据处理
sqlplus /nolog<<EXECSQL;
conn busi/"pw1234"@ORA;
drop table tab_abc;
commit;
exit;
EXECSQL