SQL & PL/SQL

Hi All,

I have a table named like TABLE_LOAN, which is containt the data as follows

region acc_no prd_cat balance interest debit
--------- ---------- ----------- -------------- ------------ ---------------
A 101 home_ln 5,00,000 50,000 5,000
A 102 vehicle_ln 1,00,000 25,000 10,000
B 103 home_ln 7,00,000 75,000 25,000
B 104 vehicle_ln 7,50,000 75,000 10,000

i need to create a report as follow

region prd_cat balance interest debit
------------- ------------ ------------- ------------ -----------
home_ln 12,00,000 1,20,000 30,000
vehicle_ln 8,50,000 1,00,000 20,000
------------------- --------------- --------------
Total 20,50,000 2,20,000 50,000
-------------------- --------------- --------------
A home_ln 5,00,000 50,000 5,000
vehicle_ln 1,00,000 25,000 10,000
------------------- ----------------- ----------------
Total 6,00,000 75,000 15,000
---------------------- ----------------- -----------------
B home_ln 7,00,000 75,000 25,000
Vehicle_ln 7,50,000 75,000 10,000
--------------------- ------------------- -----------------
14,50,000 1,50,000 35,000
--------------------- ------------------- ------------------
Report Total 20,50,000 2,20,000 50,000
----------------------- -------------------- -----------------

I decided to use oracle analytic functions to get the reports... i tried.. but i couldn't get it... anyone konw the query,kindly share with me.

-GG