Spaces between data lines are displayed when using SPOOL in SQLPlus

Question

I am trying to create a large query in sqlplus, but for some reason I see two empty rows every 558 rows.

I reel as such:

SET TERMOUT OFF SET ECHO OFF SET LINES 1000 SET FEEDBACK off SET HEADING OFF SET ARRAYSIZE 10000 SET NEWPAGE NONE SET PAGESIZE 0 SET TRIMSPOOL ON Spool D:\IPORT15.csv select query Spool OFF; EXIT 

I thought SET NEWPAGE should have taken care of this ??

Answer 1

I was able to solve this problem by setting: "SET PAGES 0"