sqlplus spooling: How to get rid of first, empty line?

Question

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

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.

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?

score 43 · Accepted Answer · edited Sep 25 '16 at 08:54

43

SET NEWPAGE NONE is the correct answer.

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

edited Sep 25 '16 at 08:54

Ludovic Kuty

4,868
3
28
42

answered Oct 10 '11 at 23:24

Tagar

13,911
6
95
110

4

Neither worked for me. Thanks anyway! However, setting heading to OFF will get rid of the empty line at the beginning at least, but I need the heading. – bitoolean Dec 17 '18 at 19:42
Best bet is to select your own header because SQLPLUS is not good at formatting headers. – alexherm Jan 24 '20 at 22:05

score 1 · Answer 2 · answered Jul 27 '23 at 14:45

1

FYI set newpage does nothing if using set markup csv on. Set markup csv on creates an LFCR at the beginning of the file which excel uses and adds a blank row.

answered Jul 27 '23 at 14:45

Papacuku

11
1

score -1 · Answer 3 · answered Apr 07 '11 at 08:37

-1

SET NEWPAGE 0

see here

answered Apr 07 '11 at 08:37

sqlplus spooling: How to get rid of first, empty line?

3 Answers3

Linked