select
SWD_IVRS_NO "IVRS NO",
SWD_NAME "NAME",
SWD_DESIG "DESIGNATION",
SWD_DT_OF_REGI "DATE OF REGISTRATION",
SWD_PROBABLE_DT "PROBABLE DISPATCH",
SWD_VERI_DISP "DISPATCH OF ELIGIBILITY REPORT",
SWD_DT_OF_AUTH "DISPATCH OF AUTHORIZATION",
SWD_RMRKS "REMARKS"  FROM(
select
1 "SEQ",
'STATUS OF PENSION CASES RECEIVED FROM 01.01.2016 TO 06.02.2017    STATUS OF SPEED POST DELIVERY CAN BE CHECKED THROUGH POSTAL DEPARTMENT  WEBSITE www.indiapost.gov.in/Tracking.aspx' SWD_IVRS_NO,
NULL SWD_NAME,
NULL SWD_DESIG,
NULL SWD_DT_OF_REGI,
NULL SWD_PROBABLE_DT,
NULL SWD_VERI_DISP,
NULL SWD_DT_OF_AUTH,
NULL SWD_RMRKS
FROM DUAL
UNION
select
2 "SEQ",
'IVRS NO' SWD_IVRS_NO,
'NAME' SWD_NAME,
'DESIGNATION' SWD_DESIG,
'DATE OF REGISTRATION' SWD_DT_OF_REGI,
'PROBABLE DISPATCH' SWD_PROBABLE_DT,
'DISPATCH OF ELIGIBILITY REPORT' SWD_VERI_DISP,
'DISPATCH OF AUTHORIZATION' SWD_DT_OF_AUTH,
'REMARKS' SWD_RMRKS
FROM DUAL
UNION
select
3 "SEQ",
SWD_IVRS_NO,
SWD_NAME,
SWD_DESIG,
TO_CHAR(SWD_DT_OF_REGI,'DD/MM/YYYY') SWD_DT_OF_REGI,
TO_CHAR(SWD_PROBABLE_DT,'DD/MM/YYYY') SWD_PROBABLE_DT,
TO_CHAR(SWD_VERI_DISP,'DD/MM/YYYY') SWD_VERI_DISP,
TO_CHAR(SWD_DT_OF_AUTH,'DD/MM/YYYY') SWD_DT_OF_AUTH,
SWD_RMRKS
from sar_web_dtls
where  SWD_DT_OF_REGI between '01-jan-2016' and '07-feb-2017'
ORDER BY 1
)