Please see the attached data which has two columns (dt and dy) which are generated through the query:
to_char(dt, 'Day') dy,
(sysdate - 100) + rownum -1 dt
connect by level <= sysdate - (sysdate - 100) + 1)
I need to add into the query another column (calc_field) which gives the count of the number of times that day has happened in that month (up to that date).
any help is appreciated