leading empty row

[dba_admin]

I am using the following script to create a report. For some reason, there is always one leading empty row and one trailing row. How do I get rid of them?

set head off
set feedback off

spool c:\my_report..txt
select e.hash_value,
(e.buffer_gets-b.buffer_gets) Total,
(e.executions -b.executions) EXECS
from stats$sql_summary b,stats$sql_summary e
where
b.snap_id=&&b_snap_id
and e.snap_id=&&e_snap_id
and e.hash_value=b.hash_value
order by (e.buffer_gets-b.buffer_gets) desc
/
spool off

[patel_dil]

If you are just trying to get rid of empty rows in result sets, Try this :

select e.hash_value,
(e.buffer_gets-b.buffer_gets) Total,
(e.executions -b.executions) EXECS
from stats$sql_summary b,stats$sql_summary e
where 
b.snap_id=&&b_snap_id 
and e.snap_id=&&e_snap_id 
and e.hash_value=b.hash_value
and e.hash_value is not null 
order by (e.buffer_gets-b.buffer_gets) desc

HTH.

[adewri]

Originally posted by dba_admin
I am using the following script to create a report. For some reason, there is always one leading empty row and one trailing row. How do I get rid of them?

set head off
set feedback off

spool c:\my_report..txt
select e.hash_value,
(e.buffer_gets-b.buffer_gets) Total,
(e.executions -b.executions) EXECS
from stats$sql_summary b,stats$sql_summary e
where
b.snap_id=&&b_snap_id
and e.snap_id=&&e_snap_id
and e.hash_value=b.hash_value
order by (e.buffer_gets-b.buffer_gets) desc
/
spool off

set pages 0

[dba_admin]

Thank you.