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

How will u register concurrent request ?

1 Answers   Convergys,

where is chandra institute in hyderabad for oracle apps technical training ?

2 Answers  

Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,

what are the balancing segments in AR?

0 Answers  

Which module is not in multiorg

6 Answers   HCL, Wipro,

You are working with interfaces if client doesnot give any flat then what will u do?

8 Answers   Wipro,

what is the purpose of standard cost update?

2 Answers   Satyam, Scan Steel,

How to attach the multiple templates in XML Pub Report?

2 Answers   Intelligroup, KPIT,

what are the different calculation columns available in reports?

1 Answers  

what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,

How many schemas we have? how many you have used?

0 Answers