spool導出實例

　　spool導出實例

　　．    增加帳戶記錄
 spool /home/mocsa/subsid_addmoneycsv
select tsubsidtacctidsum(ttransmoney)
from T_ACCTWATER t
where (trunc(tTRANSTIMEdd) between trunc(to_date(yyyymmdd)dd) and trunc(to_date(yyyymmdd)dd) )
       and tTRANSTYPE = and tREPENISHCHANNEL =
       and tsubsid in( select SubsId
                     from T_ACCTWATER
                     where (trunc(TRANSTIMEdd) between trunc(to_date(yyyymmdd)dd)
                           and trunc(to_date(yyyymmdd)dd) )
                           and TRANSTYPE = and REPENISHCHANNEL =
                     group by SubsId
                    having sum(TRANSMONEY)>)
group by tsubsidtacctid;
spool off;

From:http://tw.wingwit.com/Article/program/Oracle/201311/18475.html