"how to populate calendar table in oracle?" Code Answer


this is a simple and easy way to do it

with calendar as (
        select :startdate + rownum - 1 as day
        from dual
        connect by rownum < :enddate - :startdate
select rownum as "s.no", to_date(day,'dd_mm_yyyy') as "cal_dt", to_char(day,'day') as "dayname"
from calendar
By Fadils on June 23 2022

Answers related to “how to populate calendar table in oracle?”

Only authorized users can answer the Search term. Please sign in first, or register a free account.