本文主要是介绍oracle 调整输出的列宽、行宽，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
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
这篇关于oracle 调整输出的列宽、行宽的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
