SQL & PL/SQL

Hi friends,

Please help me to get the following output from EMP table:

DEPTNO     EMPNO     ENAME     SAL      HIREDATE
------------------------------------------------------------------------------------
10             7521        Arun         1000    01-Jan-2005
                7522       Bala           2000    01-Feb-2005 
                7523        Chitra         3000    01-Mar-2005
20             7524        Divya         4000    01-Apr-2005
                7525        Elango        5000    01-May-2005 
30             7526        Fathima      6000    01-Jun-2005
                7527        Gopal         7000     01-Jul-2005
                7528        Hari            8000    01-Aug-2005

Edited by: BluShadow on 15-Feb-2012 08:29
added {noformat}

{noformat} tags for improved (not perfect, due to OP's source) readability.  Please read {message:id=9360002} and learn to do this yourself.