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 ) |