Display monthly report
Posted on 2006-07-04
I have a table Monthly_activity with column Act_date, activity_detail
Date format : dd/mon/yyyy
... so on until 1/Dec/2006
Hence that there is NO activity in APRIL.
I want to produce a list as below.
In the list, activity for April still displayed even there is no record in April.
So how can I do this using SQL. My database is Oracle.