• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3305
  • Last Modified:

Suppress blank line at top of spool file

Hi

I am using SQLPlus script to pull data from a table and spool to a text file. The app I need the spool file for expects certain data in the first line, which is gotten from the table by my script. However the spool file always begins with a blank line. Is there any way of suppressing this blank line? I have Oracle 9.2. The script is below.

Thanks


Script
---------
set serveroutput on;
set feedback off;
set linesize 300;
set heading off;
set pagesize 50000;
set echo off;
--set termout off;
spool spoolfile.txt;
select trim(text13)
from work_table
where code1 = 'UCNTL'
order by number1
;
spool off;
set echo on;
set heading on;
--set termout on;
set feedback on;
0
miscok
Asked:
miscok
1 Solution
 
pennnnCommented:
set newpage none;
Hope that helps!
0
 
SujithData ArchitectCommented:
Hi Miscok,

Change the pagesize to - This will solve the issue.
set pagesize 0;

And add the following line too (desirable)
set trimspool on;

Rgds
Sujith.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now