Interested to Buy Any Domain ? << Click Here >> for more details...
What are the User PARAMETERS in the Reports?
- 6 Answers
- 17554 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 |
What is menu.
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
where we will put the control file ,where we will run sql star loader what is the cmd?
mention the interface tables for item open interface and open transaction interface and also their respective production tables.
what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
What are do's and dont's of Interface?
Can you explain the difference between architecture followed in 10g & 11g?
What are the files we submit while your program move to testing instance?
Write an SQL Query to Delete Duplicate records from a table using ROWID.
24 Answers pspl, Satyam, Thinkways,
Can we run a package with out specification?If yes how?
If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?
Oracle Apps Technical 
