1SQL> SET SQLFORMAT ANSICONSOLE
2SQL> SELECT * FROM emp WHERE deptno = 20;
3 EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
4 7369 SMITH CLERK 7902 17-DEC-80 800 20
5 7566 JONES MANAGER 7839 02-APR-81 2975 20
6 7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7 7876 ADAMS CLERK 7788 23-MAY-87 1100 20
8 7902 FORD ANALYST 7566 03-DEC-81 3000 20
9
10
11SQL>