SELECT * FROM Emp ORDER BY ename
EMPNO: 7876 ENAME: ADAMS JOB: CLERK MGR: 7788 HIREDATE: 12-JAN-83 SAL: 1100 COMM: DEPTNO: 20 EMPNO: 7499 ENAME: ALLEN JOB: SALESMAN MGR: 7698 HIREDATE: 20-FEB-81 SAL: 1600 COMM: 300 DEPTNO: 30 EMPNO: 7698 ENAME: BLAKE JOB: MANAGER MGR: 7839 HIREDATE: 01-MAY-81 SAL: 2850 COMM: DEPTNO: 30 EMPNO: 7782 ENAME: CLARK JOB: MANAGER MGR: 7839 HIREDATE: 09-JUN-81 SAL: 2450 COMM: DEPTNO: 10 EMPNO: 7902 ENAME: FORD JOB: ANALYST MGR: 7566 HIREDATE: 03-DEC-81 SAL: 3000 COMM: DEPTNO: 20 EMPNO: 7900 ENAME: JAMES JOB: CLERK MGR: 7698 HIREDATE: 03-DEC-81 SAL: 950 COMM: DEPTNO: 30 EMPNO: 7566 ENAME: JONES JOB: MANAGER MGR: 7839 HIREDATE: 02-APR-81 SAL: 2975 COMM: DEPTNO: 20 EMPNO: 7839 ENAME: KING JOB: PRESIDENT MGR: HIREDATE: 17-NOV-81 SAL: 5000 COMM: DEPTNO: 10 EMPNO: 7654 ENAME: MARTIN JOB: SALESMAN MGR: 7698 HIREDATE: 28-SEP-81 SAL: 1250 COMM: 1400 DEPTNO: 30 EMPNO: 7934 ENAME: MILLER JOB: CLERK MGR: 7782 HIREDATE: 23-JAN-82 SAL: 1300 COMM: DEPTNO: 10 EMPNO: 7788 ENAME: SCOTT JOB: ANALYST MGR: 7566 HIREDATE: 09-DEC-82 SAL: 3000 COMM: DEPTNO: 20 EMPNO: 7369 ENAME: SMITH JOB: CLERK MGR: 7902 HIREDATE: 17-DEC-80 SAL: 800 COMM: DEPTNO: 20 EMPNO: 7844 ENAME: TURNER JOB: SALESMAN MGR: 7698 HIREDATE: 08-SEP-81 SAL: 1500 COMM: 0 DEPTNO: 30 EMPNO: 7521 ENAME: WARD JOB: SALESMAN MGR: 7698 HIREDATE: 22-FEB-81 SAL: 1250 COMM: 500 DEPTNO: 30