What are the User PARAMETERS in the Reports?
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 |
What is count(*) from po_vendors(any table)?
how can we return morethan one parameters in procedure?
Name the different Cursor Attributes.
How can u call a standard interface program from sql or pl/sql code?
How many types of projects are there in project module?
6 Answers Fujitsu, Tech Mahindra,
q)what are the validations in sql*loader
What is the reason for distribution hold. Why invoices will go on distribution variance hold ??
what is meant by lexical parameter
what is fiscalcalendar?
What is the link between AP and GL in oracle apps R/12?
4 Answers Bosch, Collabera, Synechron,
what is the differences between internal requisition and internal sales order?
In which directory your flatfile is given?if u connected different instance where it is find?