1、设置行宽度
SQL> show linesize; //查看目前的linesize,默认是80
SQL> set linesize 100; //设置成100或者更宽都可以
2、设置页面显示总行数
SQL> show pagesize; //首先查看目前的pagesize,默认是14
SQL> set pagesize 20; //将pagesize设置好20
3、设置指定列的宽度
SQL> select name,value,issys_modifiable from v$parameter where name='control_file_record_keep_time';
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
ISSYS_MOD
---------
control_file_record_keep_time
8
IMMEDIATE
SQL> col name for a30 ---或 col name format a30
SQL> col value for a10
SQL> select name,value,issys_modifiable from v$parameter where name='control_file_record_keep_time';
NAME VALUE ISSYS_MOD
------------------------------------------- --------------- ----------------
control_file_record_keep_time 8 IMMEDIATE
SQL> col name clear ----清除还原格式
SQL> col value clear