I'd recommend that you create a table of months for this. You can do various other techniques, such as generating the rows with CONNECT BY and whatnot but you really can't beat having actual data to select -- the optimizer will thank you