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 is count(*) from po_vendors(any table)?

0 Answers  

how can we return morethan one parameters in procedure?

2 Answers  

Name the different Cursor Attributes.

2 Answers   Satyam,

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

How many types of projects are there in project module?

6 Answers   Fujitsu, Tech Mahindra,

q)what are the validations in sql*loader

0 Answers   Accenture,

What is the reason for distribution hold. Why invoices will go on distribution variance hold ??

1 Answers   Oracle,

what is meant by lexical parameter

1 Answers   Wipro,

what is fiscalcalendar?

3 Answers   CTS,

What is the link between AP and GL in oracle apps R/12?

4 Answers   Bosch, Collabera, Synechron,

what is the differences between internal requisition and internal sales order?

0 Answers   Accenture,

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers