20 ADAMS CLERK 7788 05/23/1987 $1,100.00
20 SMITH CLERK 7902 12/17/1980 $800.00
20 SCOTT ANALYST 7566 04/19/1987 $3,000.00
30 WARD SALESMAN 7698 02/22/1981 $1,250.00 $500.00
30 TURNER SALESMAN 7698 09/08/1981 $1,500.00 $.00
30 ALLEN SALESMAN 7698 02/20/1981 $1,600.00 $300.00
30 JAMES CLERK 7698 12/03/1981 $950.00
30 BLAKE MANAGER 7839 05/01/1981 $2,850.00
30 MARTIN SALESMAN 7698 09/28/1981 $1,250.00 $1,400.00
14 rows selected.
SQL> col comm clear # 清除别名
SQL> /
DEPTNO ENAME JOB MGR HIREDATE salary COMM
========== ========== ========== ========== ========== ============ ==========
10 CLARK MANAGER 7839 06/09/1981 $2,450.00
10 KING PRESIDENT 11/17/1981 $5,000.00
10 MILLER CLERK 7782 01/23/1982 $1,300.00
20 JONES MANAGER 7839 04/02/1981 $2,975.00
20 FORD ANALYST 7566 12/03/1981 $3,000.00
20 ADAMS CLERK 7788 05/23/1987 $1,100.00
20 SMITH CLERK 7902 12/17/1980 $800.00
20 SCOTT ANALYST 7566 04/19/1987 $3,000.00
30 WARD SALESMAN 7698 02/22/1981 $1,250.00 500
30 TURNER SALESMAN 7698 09/08/1981 $1,500.00 0
30 ALLEN SALESMAN 7698 02/20/1981 $1,600.00 300
30 JAMES CLERK 7698 12/03/1981 $950.00
30 BLAKE MANAGER 7839 05/01/1981 $2,850.00
30 MARTIN SALESMAN 7698 09/28/1981 $1,250.00 1400
14 rows selected.
SQL> clear columns; #清楚所有列的格式，日期列除外。
columns cleared
SQL> /
DEPTNO ENAME JOB MGR HIREDATE SAL COMM
========== ========== ========= ========== ========== ========== ==========
10 CLARK MANAGER 7839 06/09/1981 2450
10 KING PRESIDENT 11/17/1981 5000
10 MILLER CLERK 7782 01/23/1982 1300
20 JONES MANAGER 7839 04/02/1981 2975
20 FORD ANALYST 7566 12/03/1981 3000
20 ADAMS CLERK 7788 05/23/1987 1100
20 SMITH CLERK 7902 12/17/1980 800
30 WARD SALESMAN 7698 02/22/1981 1250 500
30 TURNER SALESMAN 7698 09/08/1981 1500 0
30 ALLEN SALESMAN 7698 02/20/1981 1600 300
30 JAMES CLERK 7698 12/03/1981 950
30 BLAKE MANAGER 7839 05/01/1981 2850
30 MARTIN SALESMAN 7698 09/28/1981 1250 1400
14 rows selected.
SQL> l
1 select deptno, ename, job, mgr, hiredate, sal ,comm
2 from emp
3* order by 1
SQL> save all_emp.sql; #将缓存中的sql语句保存到all_emp.sql文件中，all_emp.sql将保存在启动SQL*PLUS的文件夹。save只保存最近的sql语句。
Created file all_emp.sql
SQL> @all_emp.sql; #@all_emp来执行all_emp.sql文件。
DEPTNO ENAME JOB MGR HIREDATE SAL COMM
========== ========== ========= ========== ========== ========== ==========
10 CLARK MANAGER 7839 06/09/1981 2450
10 KING PRESIDENT 11/17/1981 5000
10 MILLER CLERK 7782 01/23/1982 1300
20 JONES MANAGER 7839 04/02/1981 2975
20 FORD ANALYST 7566 12/03/1981 3000
20 ADAMS CLERK 7788 05/23/1987 1100
20 SMITH CLERK 7902 12/17/1980 800
20 SCOTT ANALYST 7566 04/19/1987 3000
30 WARD SALESMAN 7698 02/22/1981 1250 500
30 TURNER SALESMAN 7698 09/08/1981 1500 0
30 ALLEN SALESMAN 7698 02/20/1981 1600 300
30 JAMES CLERK 7698 12/03/1981 950
30 BLAKE MANAGER 7839 05/01/1981 2850
30 MARTIN SALESMAN 7698 09/28/1981 1250 1400
14 rows selected.
SQL> 3 where job = 'PRESIDENT'
SQL> l
1 select deptno, ename, job, mgr, hiredate, sal ,comm
2 from emp
3* where job = 'PRESIDENT'
SQL> save /tmp/president.sql #将缓存中的sql语句保存到 /tmp目录下的 president.sql文件。 若该目录下已经存在同名文件，则用
SQL> save /tmp/president.sql replace
SQL> @/tmp/president.sql
DEPTNO ENAME JOB MGR HIREDATE SAL COMM
========== ========== ========= ========== ========== ========== ==========
10 KING PRESIDENT 11/17/1981 5000