I'm trying to spool a large query in sqlplus but for some reason, I see 2 blank lines every 558 rows to be exact.
I spool 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
trim(to_char(t1.D_DTM, 'mm/dd/yyyy hh24:mm:ss'))||','||
trim(t1.TECHNOLOGY)||','||
trim(t1.VOICEDATA)||','||
trim(t2.MRKT_NM)||','||
trim(t2.REGION_NM)||','||
trim(t2.CLUSTER_NM)||','||
trim(t3.BSC_NM)||','||
trim(t1.BTS_ID)||','||
trim(t1.CSCD_NM)||','||
trim(t1.SECT_SEQ_ID)||','||
trim(t1.BND_ID)||','||
trim(t1.FA_ID)||','||
trim(t1.TCE_DTCT_CALL_SETUP_F_CNT)||','||
......
trim(t1.BSM_ID)||','||
trim(t1.BSC_SEQ_ID)
from DS3R_FH_ALL_FA_LVL_KPI_SUB t1
INNER JOIN SITES_GEO_HIERARCHY t2
ON t1.CSCD_NM = t2.CSCD_NM AND t1.BTS_ID = t2.BTS_ID
INNER JOIN SITES_SYS_HIERARCHY t3
ON t1.CSCD_NM = t3.CSCD_NM AND t1.BTS_ID = t3.BTS_ID
where t1.d_dtm = to_date('11/14/2013', 'mm/dd/yyyy')
Spool OFF;
EXIT
How do I prevent the blank rows from showing up? Do i have a syntax error some where? I was under the impression that newpage and pagesize would take care of the blank rows.
Also, when I run my query in sqldev, I don't get any blank lines in the row output.....