I have the following sql which spools to some file. When I check the
txt file first line is emplty. Is there any sql setting, with which it
should not happen.

set serveroutput on size 999999

set linesize 50

set head off;

set feed off;

set title off;

set verify off;

spool /tmp/pcsd_order_ack.txt

select oeh.order_number

from oe_order_headers_all oeh,

ra_salesreps_all rsa

where nvl(oeh.attribute3,'A') = 'N'

and oeh.order_type_id <>1085

and oeh.cancelled_flag <> 'Y'

and oeh.org_id=106

and rsa.salesrep_id=oeh.salesrep_id

and rsa.name like '%PCSD%'

;



Regards,

Inder


Oracle LazyDBA home page