Peace in your life.

How to Install Microsoft office document image writter.

If you have installed Office and deleted this printer you can get back by the running the following command.

cscript c:\windows\system32\prnmngr.vbs -a -p "Microsoft Office Document Image Writer" -m "Microsoft Office Document Image Writer Driver" -r "Microsoft Document Imaging Writer Port:"

Getting Dates whether Transaction is there on not

SELECT TO_DATE(:FROM_DATE,'DD/MM/YYYY')+(ROWNUM-1) AS SUPV_DATE,
NULL AS SUPV_HRS,
NULL AS SUPV_OT
FROM ALL_OBJECTS
WHERE TO_DATE(:FROM_DATE,'DD/MM/YYYY') + (ROWNUM - 1) <= TO_DATE(:END_DATE,'DD/MM/YYYY')