CODEWITHSUNDEEP
sqloracle-databaseplsqlplsqldeveloper
Arav
Arav

Reputation: 5247

Regarding sql reporting

i am doing a spool of sql select output. i have the below sql settings 

        SET FEEDBACK OFF
        SET HEADING OFF
        SET LINESIZE 800
        SET PAGESIZE 50000
        SET TRIMSPOOL ON
        SET TERMOUT OFF
        SET ECHO OFF

The problem is there is a blank line inserted into the spool file before select statement output. Not sure what sql settings i need to add.

Upvotes: 2

Views: 101

Answers (1)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60262

It's printing a blank page heading - use:

SET PAGESIZE 0

Upvotes: 5

Related Questions