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

sql sqlplus spool fixed-length-file
user321068 picture user321068 · Apr 7, 2011 · Viewed 42k times · Source

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?

Answer

Tagar picture Tagar · Oct 11, 2011

SET NEWPAGE NONE is the correct answer.

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

Related questions

spool with column headers in pipe delimited sqlplus

I currently am spooling a pipe file via this sqlplus script: set feedback off set echo off set verify off set pagesize 0 set heading off set termout off set trim on set wrap on set trimspool on set linesize 9000 spool …

Read More
Append to spool file Oracle

I have one script file called Test.sql in D:\Scripts folder and the content of the file is given below SET SERVEROUTPUT ON SET DEFINE OFF SPOOL Test.log; SELECT USER_NAME FROM TUP_USER WHERE USER_ID=1432; SPOOL …

Read More
oracle sql plus spool

I'm using sql plus to execute a query (a select) and dump the result into a file, using spool option. I have about 14 millions lines, and it takes about 12 minutes to do the dump. I was wondering if there is …

Read More