hali

SQL> select job,empno,ename from emp order by job;JOB            EMPNO ENAME--------- ---------- ----------ANALYST         7788 SCOTTANALYST         7902 FORDCLERK           7934 MILLERCLERK           7900 JAMESCLERK           7369 SMITHCLERK           7876 ADAMSMANAGER         7698 BLAKEMANAGER         7566 JONESMANAGER         7782 CLARKPRESIDENT       7839 KINGSALESMAN        7844 TURNERSALESMAN        7654 MARTINSALESMAN        7521 WARDSALESMAN        7499 ALLEN14 rows selected.SQL> break on job skip 1SQL> select job,empno,ename from emp order by job;JOB            EMPNO ENAME--------- ---------- ----------ANALYST         7788 SCOTT                7902 FORDCLERK           7934 MILLER                7900 JAMES                7369 SMITH                7876 ADAMSMANAGER         7698 BLAKE                7566 JONES                7782 CLARKPRESIDENT       7839 KINGSALESMAN        7844 TURNER                7654 MARTIN                7521 WARD                7499 ALLEN14 rows selected.SQL>