Discussion in 'Oracle SCM & Manufacturing' started by jagadekara, Sep 26, 2013.
Is it Possible to show Calendar as list of values for date value set?
I am also expecting the perfect solution ... but meanwhile i am using the following query
SELECT (TRUNC(SYSDATE,'MON')-1)+LEVEL FROM DUAL
CONNECT BY LEVEL <= (TRUNC(LAST_DAY(SYSDATE))-TRUNC(SYSDATE,'MON'))+1;