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 can we get odd numbered pages in output of a report

2 Answers   Infosys,

can we get profile values in report without using user exists is it possible how?

0 Answers   Cap Gemini,

Can functions be overloaded ?

2 Answers  

How many parameters we can pass through pl/sql program in Oracle apps

4 Answers  

Difference between set of books id and ledger id in r12 ?

1 Answers   TCS,

what is the difference between multiorg views and multiorg tables

2 Answers   Immense Source, Intelligroup, TCS,

tell me the scenarios of the independent in reports

0 Answers   TCS, Wipro,

What are do's and dont's of Interface?

0 Answers  

HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers  

Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,

What is the use of format trigger?

4 Answers   Cap Gemini, IBM,

how to print multi lay outs,muti currency,muti language in xml publisher

2 Answers   Deloitte, Oracle,