Oracle控制台调整表线宽列宽页面大小

线宽：set linesize number;
页面大小：set pagesize number;
列宽：col COLNAME format size;

SQL> select * from emp;

EMPNO ENAME                JOB                    MGR HIREDATE              SAL
----- -------------------- -------------------- ----- -------------- ----------
      COMM     DEPTNO
---------- ----------
 7369 SMITH                CLERK                 7902 17-12月-80            800
                   20

 7499 ALLEN                SALESMAN              7698 20-2月 -81           1600
       300         30

 7521 WARD                 SALESMAN              7698 22-2月 -81           1250
       500         30


EMPNO ENAME                JOB                    MGR HIREDATE              SAL
----- -------------------- -------------------- ----- -------------- ----------
      COMM     DEPTNO
---------- ----------
 7566 JONES                MANAGER               7839 02-4月 -81           2975
                   20

 7654 MARTIN               SALESMAN              7698 28-9月 -81           1250
      1400         30

 7698 BLAKE                MANAGER               7839 01-5月 -81           2850
                   30


EMPNO ENAME                JOB                    MGR HIREDATE              SAL
----- -------------------- -------------------- ----- -------------- ----------
      COMM     DEPTNO
---------- ----------
 7782 CLARK                MANAGER               7839 09-6月 -81           2450
                   10

 7788 SCOTT                ANALYST               7566 19-4月 -87           3000
                   20

 7839 KING                 PRESIDENT                  17-11月-81           5000
                   10


EMPNO ENAME                JOB                    MGR HIREDATE              SAL
----- -------------------- -------------------- ----- -------------- ----------
      COMM     DEPTNO
---------- ----------
 7844 TURNER               SALESMAN              7698 08-9月 -81           1500
         0         30

 7876 ADAMS                CLERK                 7788 23-5月 -87           1100
                   20

 7900 JAMES                CLERK                 7698 03-12月-81            950
                   30


EMPNO ENAME                JOB                    MGR HIREDATE              SAL
----- -------------------- -------------------- ----- -------------- ----------
      COMM     DEPTNO
---------- ----------
 7902 FORD                 ANALYST               7566 03-12月-81           3000
                   20

 7934 MILLER               CLERK                 7782 23-1月 -82           1300
                   10


已选择14行。

SQL> col EMPNO format 9999
SQL> col NAME format a20
SQL> col JOB format a20
SQL> col MGR format 9999
SQL> col SAL format 9999
SQL> col COMM format 9999
SQL> col DEPTNO format 999
SQL> select * from emp;

EMPNO ENAME                JOB                    MGR HIREDATE         SAL  COMM
----- -------------------- -------------------- ----- -------------- ----- -----
DEPTNO
------
 7369 SMITH                CLERK                 7902 17-12月-80       800
    20

 7499 ALLEN                SALESMAN              7698 20-2月 -81      1600   300
    30

 7521 WARD                 SALESMAN              7698 22-2月 -81      1250   500
    30


EMPNO ENAME                JOB                    MGR HIREDATE         SAL  COMM
----- -------------------- -------------------- ----- -------------- ----- -----
DEPTNO
------
 7566 JONES                MANAGER               7839 02-4月 -81      2975
    20

 7654 MARTIN               SALESMAN              7698 28-9月 -81      1250  1400
    30

 7698 BLAKE                MANAGER               7839 01-5月 -81      2850
    30


EMPNO ENAME                JOB                    MGR HIREDATE         SAL  COMM
----- -------------------- -------------------- ----- -------------- ----- -----
DEPTNO
------
 7782 CLARK                MANAGER               7839 09-6月 -81      2450
    10

 7788 SCOTT                ANALYST               7566 19-4月 -87      3000
    20

 7839 KING                 PRESIDENT                  17-11月-81      5000
    10


EMPNO ENAME                JOB                    MGR HIREDATE         SAL  COMM
----- -------------------- -------------------- ----- -------------- ----- -----
DEPTNO
------
 7844 TURNER               SALESMAN              7698 08-9月 -81      1500     0
    30

 7876 ADAMS                CLERK                 7788 23-5月 -87      1100
    20

 7900 JAMES                CLERK                 7698 03-12月-81       950
    30


EMPNO ENAME                JOB                    MGR HIREDATE         SAL  COMM
----- -------------------- -------------------- ----- -------------- ----- -----
DEPTNO
------
 7902 FORD                 ANALYST               7566 03-12月-81      3000
    20

 7934 MILLER               CLERK                 7782 23-1月 -82      1300
    10


已选择14行。

SQL> set line size 200
SP2-0268: linesize 选项的编号无效
SQL> set linesize 200
SQL> select * from emp;

EMPNO ENAME                JOB                    MGR HIREDATE         SAL  COMM DEPTNO
----- -------------------- -------------------- ----- -------------- ----- ----- ------
 7369 SMITH                CLERK                 7902 17-12月-80       800           20
 7499 ALLEN                SALESMAN              7698 20-2月 -81      1600   300     30
 7521 WARD                 SALESMAN              7698 22-2月 -81      1250   500     30
 7566 JONES                MANAGER               7839 02-4月 -81      2975           20
 7654 MARTIN               SALESMAN              7698 28-9月 -81      1250  1400     30
 7698 BLAKE                MANAGER               7839 01-5月 -81      2850           30
 7782 CLARK                MANAGER               7839 09-6月 -81      2450           10
 7788 SCOTT                ANALYST               7566 19-4月 -87      3000           20
 7839 KING                 PRESIDENT                  17-11月-81      5000           10
 7844 TURNER               SALESMAN              7698 08-9月 -81      1500     0     30
 7876 ADAMS                CLERK                 7788 23-5月 -87      1100           20

EMPNO ENAME                JOB                    MGR HIREDATE         SAL  COMM DEPTNO
----- -------------------- -------------------- ----- -------------- ----- ----- ------
 7900 JAMES                CLERK                 7698 03-12月-81       950           30
 7902 FORD                 ANALYST               7566 03-12月-81      3000           20
 7934 MILLER               CLERK                 7782 23-1月 -82      1300           10

已选择14行。

SQL>