I can give example form Scott Schema, if you want list all employee name for a dept in single line,try below- and try same in your table case with DESC
select
deptno,
rtrim (xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames
from
emp
group by
deptno

select group_desc,
cob_cd,
SUM(CASE WHEN MONTH_ID=200901 THEN proj_trx ELSE 0 END ) as "200901" ,
SUM(CASE WHEN MONTH_ID=200902 THEN proj_trx ELSE 0 END ) as "200902"
from testing2
group by group_desc, cob_cd

select group_desc,
cob_cd,
SUM(CASE WHEN MONTH_ID=200901 THEN proj_trx ELSE 0 END ) as "200901" ,
SUM(CASE WHEN MONTH_ID=200902 THEN proj_trx ELSE 0 END ) as "200902"
from testing2
group by group_desc, cob_cd

Many thanks for the solution.

here am getting the results like this
200901
100
200
300
400

How can i get the values like below
200901
1000<total>
100
200
300
400

SELECT *
FROM ( SELECT group_desc,
CASE
WHEN group_desc IS NOT NULL AND cob_cd IS NULL THEN 'TOTAL'
ELSE cob_Cd
END,
SUM (CASE WHEN MONTH_ID = 200901 THEN proj_trx ELSE 0 END)
AS "200901",
SUM (CASE WHEN MONTH_ID = 200902 THEN proj_trx ELSE 0 END)
AS "200902"
FROM testing2
GROUP BY ROLLUP (group_desc, cob_cd))
WHERE group_desc IS NOT NULL;