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?
Printable View
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?
be brief about what you have tried, so that we can give you some solution.
-viji
U can try with expressions using date function instead using oracle SP.