定时任务如何调出一个select脚本的结果
调出结果如何展示? 可以插入一张表中,也可以返回record给其他程序接收
bdump=`$ORACLE_HOME/bin/sqlplus -s "/ as sysdba" <<EOF set heading off feedback off verify off select VALUE from v\\$diag_info where name ='Diag Trace'; exit EOF ` 复制
bdump=`$ORACLE_HOME/bin/sqlplus -s "/ as sysdba" <<EOF set heading off feedback off verify off select VALUE from v\\$diag_info where name ='Diag Trace'; exit EOF `