HOW TO USE UNION SQL TAG FOR TOTAL,PENDING

HOW TO USE UNION SQL TAG FOR TOTAL,PENDING  select 'CIVIL' DPT , COUNT(*) AS TOTAL ,SUM(DECODE(NVL(to_char(fin…