oracle 调整输出的列宽、行宽

来源：互联网发布：亚马逊大数据选品编辑：程序博客网时间：2024/06/01 10:36

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

before：

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

after：

SQL> col NAME format a30SQL> col TYPE format a20SQL> col VALUE format a20SQL> col ISDEFAULT format a20SQL> set linesize 150SQL> 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                   FALSESQL>

列宽前要加a或A

3 0