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 different types of triggers in reports

2 Answers   Oracle,

How will u register concurrent request ?

1 Answers   Convergys,

How many standard interface programs in oracle purchasing module and oracle inventory? What are they?

3 Answers   KPIT,

i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,

FLEX FIELDS?

2 Answers  

In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?

1 Answers   Oracle,

what is the difference between character mode,bitmap mode

2 Answers   IBM, Sierra Atlantica,

What are profile options?

4 Answers   Accenture,

In report we have to show two Layout? how it is and how we can see from where it?

3 Answers   IBM,

How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,

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

0 Answers  

HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers