SET TRIMOUT ON : 去除标准输出每行的拖尾空格,缺省为OFF SET TRIMSPOOL ON : 去除重定向(SPOOL)输出每行的拖尾空格,缺省为OFF
set trimspool on set trimspool off 如果trimspool设置为on,将移除spool文件中的尾部空 ,trimout同trimspool功能相似,只不过对象是控制台。使用glogin.sql或login.sql使得设置跨session生效。 If trimspool is set to on, it will remove trailing blanks in spooled files. See also trimout which does the same thing to the output to the console (terminal). Storing settings across sessions Settings (such as sqlpluscompatibility) can be stored accross sessions with the glogin.sql and/or login.sql file.
SET TRIMSPOOL ON : 去除重定向(SPOOL)输出每行的拖尾空格,缺省为OFF
如果trimspool设置为on,将移除spool文件中的尾部空 ,trimout同trimspool功能相似,只不过对象是控制台。使用glogin.sql或login.sql使得设置跨session生效。
If trimspool is set to on, it will remove trailing blanks in spooled files. See also trimout which does the same thing to the output to the console (terminal).
Storing settings across sessions
Settings (such as sqlpluscompatibility) can be stored accross sessions with the glogin.sql and/or login.sql file.