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
30 TURNER SALESMAN 7698 09/08/1981 $1,500.00
30 ALLEN SALESMAN 7698 02/20/1981 $1,600.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
14 rows selected.
set命令
SQL> set underline '=';
SQL> /
DEPTNO ENAME JOB MGR HIREDATE salary
========== ========== ========= ========== ========== ============
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
30 TURNER SALESMAN 7698 09/08/1981 $1,500.00
30 ALLEN SALESMAN 7698 02/20/1981 $1,600.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
14 rows selected.
增加一列
SQL> a ,comm #a代表add，后面两个空格，一个逗号，新加的列名。
1* select deptno, ename, job, mgr, hiredate, sal ,comm
SQL> /
DEPTNO ENAME JOB MGR HIREDATE salary COMM
========== ========== ========= ========== ========== ============ ==========
10 CLARK MANAGER 7839 06/09/1981 $2,450.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> col comm like sal heading "Commission"; #虽然此处显示的列名是salary，但调用的的时候用原来的sal。
SQL> /
DEPTNO ENAME JOB MGR HIREDATE salary Commission
========== ========== ========= ========== ========== ============ ============
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.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 job format a10 #知道列的格式
SQL> /
DEPTNO ENAME JOB MGR HIREDATE salary Commission
========== ========== ========== ========== ========== ============ ============
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