What are the User PARAMETERS in the Reports?
- 6 Answers
- 15272 Views
- Accenture, CTS, I also Faced
- E-Mail Answers
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
What is a flexfield? List out its types.
how can i print random rows in plsql table
Can you explain the difference between architecture followed in 10g & 11g?
what is global tempory table?
Can we create tables in apps schema?
Do you know where we can check the status of po?
What are do's and dont's of Interface?
what are the different transaction clauses in AR?
can we use look up type instead of a pofile option?or valueset?is it possible how?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
In oracle application how do you debug or trace errors?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Can u give the Documentation of Custom.pll in oracle apps
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
