0

I have a batch file which is running this sql script.

set pagesize 200
spool d:\Patron\Airport_Monitoring.txt
select  count (*) from (
select x.ext_plaza_id from st_ledger p, pa_lane_txn x where P.EVENT_ID in  (400,444) and p.posted_date > sysdate - 1/24 
and X.TXN_ID = P.PA_LANE_TXN_ID ) plz_list 
where plz_list.ext_plaza_id like '2002%';           
/
spool off 
exit;

The output count is being repeated twice on the output text file. Is there a way, I can have the count only written once on the output file.

COUNT(*)                                                                      
----------                                                                      
        31                                                                      

COUNT(*)                                                                      
----------                                                                      
       31                                                                      

Thanks

MK.
  • 33,605
  • 18
  • 74
  • 111
Arnab
  • 11
  • 1
  • 3

0 Answers0