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

sourcing in GL

1 Answers   Convergys,

WHAT IS REFCURSOR IN ORACLE ?

6 Answers  

Can u give the Documentation of Custom.pll in oracle apps

0 Answers  

Can We Create a Synonym On Trigger?

7 Answers   Exeter, Oracle,

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

which is the table for storing organization information?

9 Answers   Infosys, Scan Steel,

how to initialize applications?

2 Answers  

what is the use of placeholer column?

3 Answers  

Cycle of requestion to receving transaction.

1 Answers   Accenture,

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers  

The report output is 10 pages then how many times between pages report trigger will fire?

1 Answers   IBM,

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

3 Answers   Satyam,