1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Is it Possible to show Calendar as list of values for date value set?

Discussion in 'Oracle SCM & Manufacturing' started by jagadekara, Sep 26, 2013.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hai viewers,

    Is it Possible to show Calendar as list of values for date value set?
     
  2. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    I am also expecting the perfect solution ... but meanwhile i am using the following query

    Code (SQL):
    SELECT (TRUNC(SYSDATE,'MON')-1)+LEVEL FROM DUAL
    CONNECT BY LEVEL <= (TRUNC(LAST_DAY(SYSDATE))-TRUNC(SYSDATE,'MON'))+1;