TRIM[OUT] {OFF|ON}
控制SQL*Plus是否允许显示每一行之后的空格。设置为ON可提高效率。默认为ON。此变量的值不影响TRIMSPOOL。
代码
SQL
>
set
linesize
88
SQL > set trimout on
SQL > select * from scott.dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL > set trimout off
SQL > set trimout on
SQL > select * from scott.dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL > set trimout off
TRIMOUT设为OFF后,每一行都将有88个字符,而我的SQL*Plus窗口只有80个字符宽,所以一行只能显示80个字符而剩下的8个字符自动折行显示到了下一行。所以从外观上看各行记录之间都有一个空白行。
代码
SQL
>
select
*
from scott.dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON