select a.month, nvl(b.amount,0) amount --decode(b.amount,'',0) from (select to_char(sysdate, 'yyyy') || lpad(level, 2, 0) month from dual connect by level < 13) a, (select to_char(((sum(t.txn_amt) + sum(t.coupon_amt)) / 100), 'FM999,999,999,990.90')... Read More
