SQL> select job,empno,ename from emp order by job;

JOB            EMPNO ENAME
--------- ---------- ----------
ANALYST         7788 SCOTT
ANALYST         7902 FORD
CLERK           7934 MILLER
CLERK           7900 JAMES
CLERK           7369 SMITH
CLERK           7876 ADAMS
MANAGER         7698 BLAKE
MANAGER         7566 JONES
MANAGER         7782 CLARK
PRESIDENT       7839 KING
SALESMAN        7844 TURNER
SALESMAN        7654 MARTIN
SALESMAN        7521 WARD
SALESMAN        7499 ALLEN

14 rows selected.

SQL> break on job skip 1
SQL> select job,empno,ename from emp order by job;

JOB            EMPNO ENAME
--------- ---------- ----------
ANALYST         7788 SCOTT
                7902 FORD

CLERK           7934 MILLER
                7900 JAMES
                7369 SMITH
                7876 ADAMS

MANAGER         7698 BLAKE
                7566 JONES
                7782 CLARK

PRESIDENT       7839 KING

SALESMAN        7844 TURNER
                7654 MARTIN
                7521 WARD
                7499 ALLEN


14 rows selected.

SQL>