Hi All,
I need some help in getting the GL_Period's even though the table doesn't have those.
I am passing the GL_period as parameters .In my table the param_period i have is Jan-10,Feb-10,Mar-10.The parameters i am passing from_gl_period is Jan-10 and to_gl_period is Dec-10.Now i want to get all the values from Jan-10 to Dec-10 even though those are not in the table.
select parm_period,NVL(value,0) from table where parm_period between from_gl_period and to_gl_period.