oracle - Regarding sql reporting -


i doing spool of sql select output. have 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 there blank line inserted spool file before select statement output. not sure sql settings need add.

it's printing blank page heading - use:

set pagesize 0 

Comments

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

aspxgridview - Devexpress grid - header filter does not work if column is initially hidden -

c# - How to execute a particular part of code asynchronously in a class -