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>

列宽前要加a或A