Interested to Buy Any Domain ? << Click Here >> for more details...
What are the User PARAMETERS in the Reports?
- 6 Answers
- 17530 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 |
how can u find the status in po?
What is INBOUND and OUT BOUND? (Different types of interfaces)
17 Answers Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,
suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?
what are version control tools used in oracle apps?
What are the tables in GL?
what r the objects u have to do in u experiance
Sys Admin Module?
when we run payment batch what are the 3 concurrent programs?
what are the default arguments for pl/sql program?
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
In custom.pll what are the events we can Not write.
What are different execution methods of executabls?
Oracle Apps Technical 
