Required output on excel format

See more:

SQL

required data on xls format. Please help me.


set feedback off
set pagesize 0
set head off
set echo off
set linesize 500
set line 200
set verify off

SPOOL C:\DATA\ABN29977_BKG.xls

Select
'CNSG_NO' ||','||
'BKG_DATE' ||','||
'CNSGEE_NAM' ||','||
'REF_NO' ||','||
'DSTN' ||','
FROM DUAL
UNION ALL
select
substr(b.cnsg_no,1,12) ||','||
TO_CHAR(b.bkg_dat,'DD-MON-YYYY') ||','||
replace(substr(t.cnsgee_nam,1,30),',','') ||','||
replace(substr(t.cnsgee_addr1,1,20),',','') ||','||
t.dstn ||','
from oms_cnsg_bill b, oms_cnsg_track t
where b.cnsg_no=t.cnsg_no
and b.cus_no='ABN29977'
and b.bkg_dat between trunc (SYSDATE)-2 and trunc (SYSDATE)-1

/
SPOOL OFF

EXIT;