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

来源：互联网发布：actor critic知乎编辑：程序博客网时间：2024/06/06 12:52
线宽：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         30EMPNO 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                   30EMPNO 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                   10EMPNO 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                   30EMPNO 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 9999SQL> col NAME format a20SQL> col JOB format a20SQL> col MGR format 9999SQL> col SAL format 9999SQL> col COMM format 9999SQL> col DEPTNO format 999SQL> 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    30EMPNO 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    30EMPNO 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    10EMPNO 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    30EMPNO 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 200SP2-0268: linesize 选项的编号无效SQL> set linesize 200SQL> 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           20EMPNO 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>
阅读全文
0 0