oracle调整显示长宽,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