That's a very good tip,dgo. I suggest to add TRUNC in your tip to get all dates of the given month.
select TRUNC(to_date('01-JAN-02','dd-MON-yy'),'MON') + rownum - 1 day
from all_objects
where
rownum <= to_char(add_months(TRUNC(to_date('01-JAN-02','dd-MON-yy'),'MON'),1)-1,'dd')
where do you want these dates to appear? IN LOV or in List Item, or somewhere else, I cant think of any solution which can achieve what you want In a single query. probably you may have to use PL/SQL block.
so where/why you want to have all the dates? I am asking so that if there could be...
BJCooperIT,
What if post is issued instead of commit in your suggetion? Vsimmons, why after posting the control is passed to another form? Could you find out the reason?
If this item is database item, then you dont have to do anything to store this item in database, as you have given the formula, value will be calculated on its own. and if it is not database item, u will have to write insert/update statment.
Hi sumitha
what ehpt has suggested is correct in my view. you need to create a parameter list and then add parameter by following syntax
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
this would work. correct me if i am wrong.
Best Luck,
Dharmesh
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.