Wednesday, January 24, 2007

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