What are the User PARAMETERS in the Reports?
Answer Posted / vasu
Whenever you need to change the query value at runtime then
create a parameter which reads the value during run time.
In this scenario which you are creating the parameters are
known as user parameters.
eg: create a sql query as below:
select * from emp where deptno=:p_deptno
Then system creates a parameter named p_deptno. This bind
parameter is a user parameter.
Run the report, During run time system expect the deptno
value from the user.
I hope you understood.
| Is This Answer Correct ? | 20 Yes | 0 No |
Post New Answer View All Answers
how do you describe O2C along with tables
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
What is a flexfield? List out its types.
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What is instead of trigger in where we will use?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
please send me forms, xml pulisher questions,answers
List the various types of value set.
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Which oracle apps version you are very confident in?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
How do you register report in oracle apps?
How to move the one file from one instance to another instance? And your scripts also?
What do you understand by soa and what are the benefits of using this architecture?
how to print multi lay outs,muti currency,muti language in xml publisher