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

html - Instapaper-like algorithm -

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