sqlplus后台处理:如何摆脱第一个空行? [英] sqlplus spooling: How to get rid of first, empty line?

问题描述

我正在执行以下假脱机声明:

I'm doing the following spooling statement:

SET VERIFY OFF
SET FEEDBACK OFF
SET HEADING OFF
SET TRIMSPOOL ON
SET TERM OFF
SPOOL &pathRelations
START scripts/relations.sql &parent
SPOOL OFF
SET TERM ON

scripts/relations.sql文件包含一个简单的select语句.

The scripts/relations.sql file contains a simple select statement.

不幸的是，假脱机文件包含一个空行作为文件中的第一行.这行会给我们的框架带来麻烦.

Unfortunately, the spooled file contains an empty line as the first one in the file. This line causes trouble in our framework.

我当然可以通过sed摆脱这些行，但是首先没有办法抑制它的创建吗?

Of course I could get rid of these line through sed but ain't there a way to suppress its creation in the first place?

推荐答案

SET NEWPAGE NONE是正确的答案.

SET NEWPAGE 0将导致分页，这不是OP想要的.

SET NEWPAGE 0 will cause a page feed, which is not what the OP wants.

这篇关于sqlplus后台处理:如何摆脱第一个空行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！