Уважаемые форумчане есть такой запрос и результат.мне нужно в конце(в самом низу) данной таблицы ИТОГИ(суммы) по столбцам.
Помогите как быть?
select C_PkgDep.fGetNameDep(t2.ID) as TO_DEP_NAME,
U_Pkgdep.fPostindex(t2.ID) as TO_DEP_CODE,
nvl(t1.cnt,0) cnt,
nvl(t1.OBUCH,0)OBUCH,
nvl(t1.NALOJ,0) NALOJ,
nvl(t1.ned_obuch,0)ned_obuch,
nvl(t1.ned_naloj,0) ned_naloj,
nvl(t1.OBUCH_D,0) OBUCH_D,
nvl(t1.S_NALOJ_D,0) S_NALOJ_D,
nvl((t1.ned_obuch + t1.ned_naloj),0) HRANENIE
from(
select TO_DEP_NAME,
count(barcode)cnt,
sum(OBUCH)OBUCH ,
sum(NALOJ)NALOJ,
sum(ned_obuch)ned_obuch,
sum(ned_naloj)ned_naloj,
case when sum(obuch) != 0 then round(((sum(obuch)-sum(ned_obuch))*100/sum(obuch)),1) else 0 end as OBUCH_D,
case when sum(naloj) != 0 then round(((sum(naloj)-sum(ned_naloj))*100/sum(naloj)),1) else 0 end as S_NALOJ_D

from (
select t.*,
case when STATE_CODE in ('S_STRSC','S_STR') and t.mailctg not in ('4','2') then 1
else 0 end as NED_OBUCH,
case when STATE_CODE in ('S_STRSC','S_STR') and t.mailctg in ('4','2') then 1
else 0 end as NED_NALOJ
from (
select m.DEP_ID as TO_DEP_NAME,
um.barcode,
um.mailctg,
case when um.mailctg not in ('4','2') then 1
else 0 end as OBUCH,
case when um.mailctg in ('4','2') then 1
else 0 end as NALOJ,
U_PKGSRT.fBopStateExecDt(scordtl.PROC_ID,um.DEP_ID,um.ID,(select U_PKGSRT.fLastExecDt(mo.dep_id,mo.id) as DOCDOPER from dual)) as STATE_CODE
from
U_MLORD mo, T_PROCMEM m, T_ORD o, C_USR u, U_DELIVREG ud, U_PSTMAN psm, U_DLVBILLDTL dtl,
T_BOP_STAT s, T_PROCESS p, C_CLASS cc, C_ENTITY ce,
(select
Bs_Bop.fGetBopID('PST_DLVORD') as BOP_ID,
Bs_Scen.fGetScenNOrd(Bs_Bop.fGetBopID('PST_DLVORD'), 'PROCESS') as PROC_NORD
from dual) prm,
U_SCORDDTL scordtl,
u_mail um

where p.ID = m.ID
and u.ID(+) = o.ID_US
and M.MAINFL = '1'
and s.ID = p.BOP_ID and s.NORD = p.NSTAT
and mo.ID = m.ORD_ID and mo.dep_id = m.dep_id
and mo.id = o.id and mo.dep_id = o.dep_id
and mo.ent_id = o.ord_id
and ud.ID(+) = mo.dlv_id
and o.ord_id = ce.id
and cc.code = ce.code
and ce.CODE = 'U_MLDLVORD'
and dtl.DEP_ID = mo.DEP_ID
and dtl.ID = mo.ID
and psm.DEP_ID = dtl.PSTMAN_DEP_ID
and psm.ID = dtl.PSTMAN_ID
and scordtl.DEP_ID = mo.DEP_ID
and scordtl.ID = mo.ID
and um.id=scordtl.id_dtl
and um.dep_id=scordtl.dep_id_dtl
and s.code in ('S_ISSUED','S_PROCESSED')
and mo.DEP_ID+0 = any(select id from c_dep start with code = &DEP_CODE connect by prior id=id_hi)
and mo.DRECV <= &DEND
and mo.DRECV >= &DBEG
and um.mailtype in ('7','C','D','H','J','K','L','N','O','Q','S','W','Z')
)t
)
group by TO_DEP_NAME
)t1 right join
c_dep t2
on t1.TO_DEP_NAME = t2.id
where t2.ID = any(select id from c_dep start with code = &DEP_CODE connect by prior id=id_hi)

Пробовал через UNION,но никак не получается

XMLer,там ничего не понятно