sqlplus传入shell变量

 

log_db_1=`sqlplus -S dsg/dsg#123DSG << EOF
set heading off feedback off pagesize 0 verify off echo off numwidth 5;
select sequence# from v\\\$log where THREAD#=1 and status='CURRENT';  

#注意点 \ 要转义
exit
EOF`

posted on 2014-10-01 16:36  woodyx  阅读(704)  评论(0编辑  收藏  举报

导航