oracle spool

dbstr="COMS_COMMON/COMS_COMMON@QDCJ"
echo "-->【`date "+%Y%m%d%H%M%S"`】导出CH_NGSETTLE_RULE_EXPR表的业务编码"
sqlplus -S ${dbstr} <<!
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
alter session set db_file_multiblock_read_count = 64;
set pagesize 0
set term off
set trims on
set line 2000
set timing off
set feedback off


spool  ./1.txt
SELECT DISTINCT OPNID FROM CH_NGSETTLE_RULE_EXPR;
spool off;




exit;
!