oracle 调整输出的列宽、行宽

调整列宽col，调整行宽set linesize

before：

C:\>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 3月 30 21:39:32 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
 
SQL> select name,type,value,isdefault from v$parameter where name='db_file_multiblock_read_count';
 
NAME
--------------------------------------------------------------------------------
      TYPE
----------
VALUE
--------------------------------------------------------------------------------
ISDEFAULT
---------
db_file_multiblock_read_count
         3
16
FALSE
 
 
SQL>

after：

SQL> col NAME format a30
SQL> col TYPE format a20
SQL> col VALUE format a20
SQL> col ISDEFAULT format a20
SQL> set linesize 150
SQL> select name,type,value,isdefault from v$parameter where name='db_file_multiblock_read_count';
 
NAME                                 TYPE VALUE                ISDEFAULT
------------------------------ ---------- -------------------- --------------------
db_file_multiblock_read_count  ########## 16                   FALSE
 
SQL>

×

e2c

(๑＞ڡ＜)☆谢谢老板~

2元 5元 10元 50元 100元 任意金额

2元

使用微信扫描二维码完成支付