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.

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.

Answer / muneer

2 types
lexical
bind

Answer / pulla.reddy@oracle.com

Hi Prasad,

Muneer answer is correct according to question.
Good explanation from vasu.

Answer / siva

when ever u create a bind parameter in select statement
it tends to user parameter

Answer / sushil

P_CONC_REQUEST_ID
P_FLEX_VALUE

What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,

Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,

Can function be overload?

4 Answers  

Do you know what are user profiles in apps. Any examples you can give?

0 Answers  

What do you understand by concurrent programs?

0 Answers  

What is function?

2 Answers   Motorola,

in reports token is casesensitive or not?

2 Answers  

can we use anchor propery in XML reports?if yes?explain?

2 Answers   Oracle,

what is the use of anchors?

2 Answers   IBM,

Which module is not in multiorg

6 Answers   HCL, Wipro,

What r the validation done in ap inbound ?

2 Answers   Questam,

tell me the scenarios of between pages in reports

5 Answers