What are the User PARAMETERS in the Reports?
- 6 Answers
- 15212 Views
- Accenture, CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pr@$@d.
Good Eplanation V@$u.
User paramters created by user according to thier needs.
Those we call it as bind variable in report it will be
prefix with :var1 like that.
We can refer Vasu Explanation.
Regards,
-Prasad.
Regards,
-Prasad.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / pulla.reddy@oracle.com
Hi Prasad,
Muneer answer is correct according to question.
Good explanation from vasu.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / siva
when ever u create a bind parameter in select statement
it tends to user parameter
| Is This Answer Correct ? | 1 Yes | 0 No |
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What should be the batch size (number of customer records) general guidelines for optimal performance?
What do you understand by soa and what are the benefits of using this architecture?
Can you have two stored functions with in the same name?
do you know is it possible to run the interface without using oracle apps?
In thet custom.pll what are the events we can write.
how will u do documentation
What are different execution methods of executabls?
what is the data type of lexical parameter?
what is difference between d2k report and oracle apps report
How to insert data into two tables using single control file?
How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/
Oracle Apps Technical 
