Sql - list all dates in month, year etc

From: Steve Corbett <stevec_at_fcs.wa.gov.au>
Date: 1997/07/21
Message-ID: <33D311F6.35F8@fcs.wa.gov.au>#1/1

is there anything like 'select sysdate from dual' that will list all the dates in a particular month or year etc? without having to have a table of all possible dates?
i want to join this list to another table to end up with something like: Date Count

01-FEB-97   3
02-FEB-97   0
03-FEB-97   2
04-FEB-97   0

...
28-FEB-97 9 that is, i want the date listed even if the count is zero.

pre-thanks,

-- 
Steve Corbett.       Perth  Australia  .       
stevec_at_fcs.wa.gov.au
scorbett_at_perth.dialix.oz.au

Received on Mon Jul 21 1997 - 00:00:00 CDT