spool用法示例

下面文章简单介绍了一下spool的用法

[@more@]

set pagesize 0; --//##分页
set echo off; --//##显示脚本中正在执行的SQL语句
set space 0; --//##输出列间空格数
set newp none; --//##页和页之间间隔
set verify off; --//##文件校验
set termout off; --//##屏幕内容输出
set trimout on; --//##标准输出每行的拖尾空格
set trimspool on; --//##重定向（spool）输出每行的拖尾空格
set feedback off; --//##查询的行数
set colsep =; --//##域输出分隔符
set heading off; --//##列标题
set linesize 500; --//##行允许字符数
set timing off; --//## 显示每条sql命令的耗时

--day

spool /yz_data/jyfxtocrm/BC_OTHER_CALLTRAN.TXT;
select USER_NO||'|'||MOBILE_NUMBER||'|'||MOBILE_ZONE||'|'||TELE_TYPE||'|'||OPPOSE_DEALER_CODE||'|'||CDR_COUNT||'|'||CALL_DURATION from EBA.BC_OTHER_CALLTRAN where INS_FLAG=(select INS_FLAG from EBA.BC_OTHER_TOCRM_FLAG where TAB_FLAG='0' and TAB_STATE='0');
spool off;
spool /yz_data/jyfxtocrm/BC_OTHER_OPPOSE_NUMBER.TXT;
select USER_NO||'|'||MOBILE_NUMBER||'|'||MOBILE_ZONE||'|'||TELE_TYPE||'|'||OPPOSE_DEALER_CODE||'|'||OPPOSE_NUMBER||'|'||CDR_COUNT||'|'||CALL_DURATION||'|'||CDR_TYPE||'|'||CDR_ZONE from EBA.BC_OTHER_OPPOSE_NUMBER where INS_FLAG=(select INS_FLAG from EBA.BC_OTHER_TOCRM_FLAG where TAB_FLAG='0' and TAB_STATE='0') ;
spool off;
spool /yz_data/jyfxtocrm/BC_OTHER_SERV_CDR.TXT;
select USER_NO||'|'||MOBILE_NUMBER||'|'||MOBILE_ZONE||'|'||TELE_TYPE||'|'||OPPOSE_DEALER_CODE||'|'||CDR_COUNT||'|'||CALL_DURATION from EBA.BC_OTHER_SERV_CDR where INS_FLAG=(select INS_FLAG from EBA.BC_OTHER_TOCRM_FLAG where TAB_FLAG='0' and TAB_STATE='0');
spool off;

--month

spool /yz_data/jyfxtocrm/BC_OTHER_CDR_MONTH;
select USER_NO||'|'||MOBILE_NUMBER||'|'||SUB_LOCAL_NET||'|'||TELE_TYPE||'|'||OPPOSE_DEALER_CODE||'|'||OPPOSE_NUMBER||'|'||CALL_DURATION||'|'||CDR_TYPE||'|'||CDR_ZONE from EBA.BC_OTHER_CDR_MONTH where ACCT_MONTH=(select ACCT_DATE from EBA.BC_OTHER_TOCRM_FLAG where TAB_FLAG='0' and TAB_STATE='1');
spool off;
spool /yz_data/jyfxtocrm/BC_USER_CALL_MONTH;
select USER_NO||'|'||MOBILE_NUMBER||'|'||SUB_LOCAL_NET||'|'||TELE_TYPE||'|'||CALL_FLAG||'|'||CDR_NUMBER||'|'||CALL_DURATION from EBA.BC_USER_CALL_MONTH where ACCT_MONTH=(select ACCT_DATE from EBA.BC_OTHER_TOCRM_FLAG where TAB_FLAG='0' and TAB_STATE='1');
spool off;

exit;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/41451/viewspace-1001392/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/41451/viewspace-1001392/