如何在shell脚本中嵌入Oracle数据库操作
发布网友
共1个回答
热心网友
如何在shell脚本中嵌入Oracle数据库操作
sqlplus -S system/system <<EOF
set feedback off
set heading off
set pagesize 0
set linesize 200
set echo off
set termout off
spool txt/fbfjmxb.txt
select * from ORD_PEO_TXNPCL WHERE SUBSTR(TRIM(YJHM),1,1)='9' AND TRUNC(CLDATE,'dd')=TRUNC(SYSDATE,'dd');
spool off
exit;
EOF
