Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

blank lines between rows of data in sqlplus spool

k1ng87Dec 4 2013 — edited Dec 5 2013

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.....

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2014
Added on Dec 4 2013
4 comments
11,487 views