Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql Query GL Period Help

user11164339Oct 21 2014 — edited Oct 21 2014

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2014
Added on Oct 21 2014
1 comment
438 views