不知怎样设置linesize和pagesize合适!
如何格式化以下输出数据:SQL> select * from v$logfile; GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
3 STALE ONLINE
/home/oracle/redo03.log
NO 2 ONLINE
/home/oracle/redo02.log
NO GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
--- 1 STALE ONLINE
/home/oracle/redo01.log
NO
如何格式化以下输出数据:SQL> select * from v$logfile; GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
3 STALE ONLINE
/home/oracle/redo03.log
NO 2 ONLINE
/home/oracle/redo02.log
NO GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
--- 1 STALE ONLINE
/home/oracle/redo01.log
NO
SQL> set pagesize 1000
SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER
---------- ------- ------- -------------------------------------------------------
1 ONLINE /dev/rlv_redo01
2 ONLINE /dev/rlv_redo02
3 ONLINE /dev/rlv_redo03SQL>
上面是简单控制,如果不满意,可以使用col <列名> for a<宽度> 进行精确控制列宽
不过如果提示有行被截断的话 就应该set linesize了