在命令提示符下 操作Oracle 显示结果不在一行……

Question

我在cmd命令提示符下 查询了emp表显示比较混乱  如下所示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                                                                      
                                                                                
      1234 陈威       工程师                                   90000            
        30                                                                      
                                                                                     EMPNO ENAME      JOB              MGR HIREDATE              SAL       COMM 
---------- ---------- --------- ---------- -------------- ---------- ---------- 
    DEPTNO                                                                      
----------                                                                      
      1235 陈威       设计师                                    8500            
        20                                                                      结果在两行显示  。 EMPNO ENAME      JOB              MGR HIREDATE              SAL       COMM 
---------- ---------- --------- ---------- -------------- ---------- ---------- 
    DEPTNO                                                                      
----------              请问高手 如何使查询记录在一行显示呢，这样看起来比较整齐。

Answer 1

先把cmd窗口的宽度设置成100
再把行的长度设置大一些SQL>set linesize 120;
SQL> select * from emp;

Answer 2

sqlplus就是这样的了，反正我还没有听说过在cmd中可以正归显示的。
建议用plsql

Answer 3

这是你查询的表里面的内容比较多，由于窗口的限制，在显示的时候，无法在同一行全部显示，就变成那样了；可以把窗口设置的大一点，或者使用SQL*PLUS命令对输出的命令格式化，使之更美观，清晰些。

Answer 4

其实是可以的，先修改cmd窗口的属性，把宽度限制放大一些
再用SQL>set linesize 120;120相对于emp表已经够了。
LZ不妨试一下

Answer 5

oracle自带的sql*plus很不好用，建议使用第三方的pl sql developer

Answer 6

set linesize 120; 管用吗?楼主还是使用column column_name format aXX来格式化吧

Answer 7

SQL> select * from emp;     EMPNO ENAME      JOB              MGR HIREDATE               SAL       COMM---------- ---------- --------- ---------- --------------- ---------- ----------    DEPTNO
----------
      7369 SMITH      CLERK           7902 17-DEC-80              800
        20      7499 ALLEN      SALESMAN        7698 20-FEB-81             1600        300        30      7521 WARD       SALESMAN        7698 22-FEB-81             1250        500        30
     EMPNO ENAME      JOB              MGR HIREDATE               SAL       COMM---------- ---------- --------- ---------- --------------- ---------- ----------    DEPTNO
----------
      7566 JONES      MANAGER         7839 02-APR-81             2975
        20      7654 MARTIN     SALESMAN        7698 28-SEP-81             1250       1400        30      7698 BLAKE      MANAGER         7839 01-MAY-81             2850
        30
     EMPNO ENAME      JOB              MGR HIREDATE               SAL       COMM---------- ---------- --------- ---------- --------------- ---------- ----------    DEPTNO
----------
      7782 CLARK      MANAGER         7839 09-JUN-81             2450
        10      7788 SCOTT      ANALYST         7566 19-APR-87             3000
        20      7839 KING       PRESIDENT            17-NOV-81             5000
        10
     EMPNO ENAME      JOB              MGR HIREDATE               SAL       COMM---------- ---------- --------- ---------- --------------- ---------- ----------    DEPTNO
----------
      7844 TURNER     SALESMAN        7698 08-SEP-81             1500          0        30      7876 ADAMS      CLERK           7788 23-MAY-87             1100
        20      7900 JAMES      CLERK           7698 03-DEC-81              950
        30
     EMPNO ENAME      JOB              MGR HIREDATE               SAL       COMM---------- ---------- --------- ---------- --------------- ---------- ----------    DEPTNO
----------
      7902 FORD       ANALYST         7566 03-DEC-81             3000
        20      7934 MILLER     CLERK           7782 23-JAN-82             1300
        10
14 rows selected.SQL> set linesize 120
SQL> /     EMPNO ENAME      JOB              MGR HIREDATE               SAL       COMM
     DEPTNO
---------- ---------- --------- ---------- --------------- ---------- ----------
 ----------
      7369 SMITH      CLERK           7902 17-DEC-80              800
         20
      7499 ALLEN      SALESMAN        7698 20-FEB-81             1600        300
         30
      7521 WARD       SALESMAN        7698 22-FEB-81             1250        500
         30
      7566 JONES      MANAGER         7839 02-APR-81             2975
         20
      7654 MARTIN     SALESMAN        7698 28-SEP-81             1250       1400
         30
      7698 BLAKE      MANAGER         7839 01-MAY-81             2850
         30
      7782 CLARK      MANAGER         7839 09-JUN-81             2450
         10
      7788 SCOTT      ANALYST         7566 19-APR-87             3000
         20
      7839 KING       PRESIDENT            17-NOV-81             5000
         10
      7844 TURNER     SALESMAN        7698 08-SEP-81             1500          0
         30
      7876 ADAMS      CLERK           7788 23-MAY-87             1100
         20     EMPNO ENAME      JOB              MGR HIREDATE               SAL       COMM
     DEPTNO
---------- ---------- --------- ---------- --------------- ---------- ----------
 ----------
      7900 JAMES      CLERK           7698 03-DEC-81              950
         30
      7902 FORD       ANALYST         7566 03-DEC-81             3000
         20
      7934 MILLER     CLERK           7782 23-JAN-82             1300
         1014 rows selected.

Answer 8

SQL> col ename format a10
SQL> col job format a10
SQL> col empno format 9999
SQL> col mgr format 9999
SQL> col sal format 9999
SQL> col comm format 9999
SQL> /EMPNO ENAME      JOB          MGR HIREDATE          SAL  COMM     DEPTNO
----- ---------- ---------- ----- --------------- ----- ----- ----------
 7369 SMITH      CLERK       7902 17-DEC-80         800               20
 7499 ALLEN      SALESMAN    7698 20-FEB-81        1600   300         30
 7521 WARD       SALESMAN    7698 22-FEB-81        1250   500         30
 7566 JONES      MANAGER     7839 02-APR-81        2975               20
 7654 MARTIN     SALESMAN    7698 28-SEP-81        1250  1400         30
 7698 BLAKE      MANAGER     7839 01-MAY-81        2850               30
 7782 CLARK      MANAGER     7839 09-JUN-81        2450               10
 7788 SCOTT      ANALYST     7566 19-APR-87        3000               20
 7839 KING       PRESIDENT        17-NOV-81        5000               10
 7844 TURNER     SALESMAN    7698 08-SEP-81        1500     0         30
 7876 ADAMS      CLERK       7788 23-MAY-87        1100               20EMPNO ENAME      JOB          MGR HIREDATE          SAL  COMM     DEPTNO
----- ---------- ---------- ----- --------------- ----- ----- ----------
 7900 JAMES      CLERK       7698 03-DEC-81         950               30
 7902 FORD       ANALYST     7566 03-DEC-81        3000               20
 7934 MILLER     CLERK       7782 23-JAN-82        1300               1014 rows selected.

Answer 9

SQL> show linesize;
linesize 80
SQL> set linesize 150;
SQL> show linesize;
linesize 150
SQL> selecet * from scott.emp;
SP2-0734: 未知的命令开头 "selecet * ..." - 忽略了剩余的行。
SQL> select * from scott.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行。这样就行了

Answer 10

能给解释以下col ename format a10这里的a10使什么意思吗？

Answer 11

奇怪 我的set linesize 150怎么不行呢
SQL> set linesize 150
SQL> /     EMPNO ENAME      JOB              MGR HIREDATE               SAL       COMM
     DEPTNO
---------- ---------- --------- ---------- --------------- ---------- ----------
 ----------
      7369 SMITH      CLERK           7902 17-DEC-80              800
         20
      7499 ALLEN      SALESMAN        7698 20-FEB-81             1600        300
         30
      7521 WARD       SALESMAN        7698 22-FEB-81             1250        500
         30
      7566 JONES      MANAGER         7839 02-APR-81             2975
         20
      7654 MARTIN     SALESMAN        7698 28-SEP-81             1250       1400
         30
      7698 BLAKE      MANAGER         7839 01-MAY-81             2850
         30
      7782 CLARK      MANAGER         7839 09-JUN-81             2450
         10
      7788 SCOTT      ANALYST         7566 19-APR-87             3000
         20
      7839 KING       PRESIDENT            17-NOV-81             5000
         10
      7844 TURNER     SALESMAN        7698 08-SEP-81             1500          0
         30
      7876 ADAMS      CLERK           7788 23-MAY-87             1100
         20     EMPNO ENAME      JOB              MGR HIREDATE               SAL       COMM
     DEPTNO
---------- ---------- --------- ---------- --------------- ---------- ----------
 ----------
      7900 JAMES      CLERK           7698 03-DEC-81              950
         30
      7902 FORD       ANALYST         7566 03-DEC-81             3000
         20
      7934 MILLER     CLERK           7782 23-JAN-82             1300
         1014 rows selected.

Answer 12

http://blog.csdn.net/wh62592855/archive/2009/10/19/4699543.aspxSQLPLUS的使用

Answer 13

set linesize 120;
unix 下也有这个问题的，
SET 一下LINESIZE 就可以了!