I have to popluate a date time dimesion with all the days of three years (2005,2006,2007) without using stored procedures in Oracle.. is there any way to go about that?