HOW TO CONVERT ROWS INTO COLUMNS IN ORACLE SQL

 SELECT * FROM (
 SELECT SAL, HIREDATE,(CASE DEPTNO WHEN 10 THEN 'ACCOUNTING' WHEN 20 THEN 'RESEARCH' ELSE 'MARKETING'  END) DNAME
   from EMP)
PIVOT
(
   MIN(SAL)
   FOR  HIREDATE IN ('17-DEC-80','20-FEB-81','17-NOV-81')
);