Using the PIVOT function to obtain cross-tabular results

 Using the PIVOT function to obtain cross-tabular results
SQL> select *
2 from (select department_id, salary
3 from employee) total_department_sals
4 PIVOT (SUM(salary)
5 FOR department_id IN (10 AS Accounting, 20 AS Payroll, 30 AS IT,
6 NULL AS Unassigned_Department));
ACCOUNTING        PAYROLL                IT                       UNASSIGNED_DEPARTMENT

370000                          155000               370000                                 75000
1 row selected.