spool导出实例

spool导出实例：

1．    增加帐户记录：
 spool /home/mocsa/subsid_addmoney1.csv
select t.subsid,t.acctid,sum(t.transmoney)
from T_ACCTWATER t
where (trunc(t.TRANSTIME,'dd') between trunc(to_date('20070929','yyyymmdd'),'dd') and trunc(to_date('20071016','yyyymmdd'),'dd') )
       and t.TRANSTYPE = 11 and t.REPENISHCHANNEL = '307'
       and t.subsid in( select SubsId
                     from T_ACCTWATER
                     where (trunc(TRANSTIME,'dd') between trunc(to_date('20070929','yyyymmdd'),'dd')
                           and trunc(to_date('20071016','yyyymmdd'),'dd') )
                           and TRANSTYPE = 11 and REPENISHCHANNEL = '307'
                     group by SubsId
                    having sum(TRANSMONEY)>10000)
group by t.subsid,t.acctid;
spool off;