Oracle Date display Code

Requirement: if a Month from drop down list gets selected, the corresponding days populates in the tabular form. For ex, if January 2008 gets selected, then it should populate 1st january-Tuesday,2nd January-Wednesday and so on.
Option 1:
SELECT TO_CHAR(SYSDATE, ‘fmDDTH’)||’ of ‘||TO_CHAR (SYSDATE, ‘fmMonth – day’)||’, ‘||TO_CHAR(SYSDATE, ‘YYYY’) “Ides” FROM DUAL
Option 2:
CREATE OR REPLACE PROCEDURE show_dates (i_date [...]

Read Full Post »