1       11:30:24  SQL Execute: ORACLE - select  '售卡：'||substr(SF_SF_STKQK('20120415','20120415'),2)||';' ickh00 from dual   union all select  '退卡：'||substr(SF_SF_STKQK_1('20120415','20120415'),2)||';' ickh00 from dual  union all  select '售卡总数: '||to_char(count(*))||'张' ickh00  from ic_ywls00  a ,IC_YHXX00 b  where a.ickh00 =b.ickh00  and b.kldh00 ='SLE4442' and ywcz00='1' and CZRQ00 between '20120415' and '20120415'  union all select '退卡总数: '||to_char(count(*))||'张' ickh00 from ic_ywls00   a ,IC_YHXX00 b  where a.ickh00 =b.ickh00 and b.kldh00 ='SLE4442' and  ywcz00='5' and CZRQ00 between '20120415' and '20120415'  union all select '售卡总金额: '||to_char(count(*)*5)||'元' ickh00 from ic_ywls00   a ,IC_YHXX00 b  where a.ickh00 =b.ickh00 and b.kldh00 ='SLE4442' and  ywcz00='1' and CZRQ00 between '20120415' and '20120415'  union all select '退卡总金额: '||to_char(count(*)*5)||'元' ickh00 from ic_ywls00   a ,IC_YHXX00 b  where a.ickh00 =b.ickh00 and b.kldh00 ='SLE4442' and  ywcz00='5' and CZRQ00 between '20120415' and '20120415'   union all   select '合计: '||to_char(SKJE00-TKJE00)||'元' FROM ( select to_char(count(decode(ywcz00,'1',1))*5) SKJE00,  to_char(count(decode(ywcz00,'5',1))*5) TKJE00 from ic_ywls00   a ,IC_YHXX00 b   where a.ickh00 =b.ickh00 and b.kldh00 ='SLE4442' and a.CZRQ00 between '20120415' and '20120415' )