oracle 排版,oracle中查看信息的时候修改它的排版相当的麻烦！

其中[note2]引用的链接我无法打开。http://groups.google.com/group/m ... 12a35c?dmode=source

简单的在Windows 7和Windows XP上分别做了一个实验，您指的应该是那个空行问题吧，的确如此。

1.将Windows command console设置为60时

sec@ora10g> set linesize 60

sec@ora10g> select * from v$version;

BANNER

------------------------------------------------------------

------------------------------------------------------------

--------

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 -

64bi

PL/SQL Release 10.2.0.3.0 - Production

CORE    10.2.0.3.0      Production

TNS for Linux: Version 10.2.0.3.0 - Production

NLSRTL Version 10.2.0.3.0 - Production

sec@ora10g> create table tt (x varchar2(60));

Table created.

初始化一条长度为60的字符串。

sec@ora10g> insert into tt values ('123456789012345678901234567890123456789012345678901234567890');

1 row created.

sec@ora10g> col x for a60

sec@ora10g> select * from tt;

X

------------------------------------------------------------

123456789012345678901234567890123456789012345678901234567890

问题出现了，出现了一个空行！

sec@ora10g> col x for a59

sec@ora10g> select * from tt;

X

-----------------------------------------------------------

12345678901234567890123456789012345678901234567890123456789

0

2.将Windows command console设置为61后，问题已不在。

sec@ora10g> col x for a60

sec@ora10g> select * from tt;

X

------------------------------------------------------------

123456789012345678901234567890123456789012345678901234567890

secooler