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
Post a Comment