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

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,

What is responsibility?

5 Answers  

After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?

3 Answers   IBM,

What does appl_top directory contain?

0 Answers  

what is difference between po_headers_all and po_headers

2 Answers   NTT Data,

in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?

1 Answers   KPMG,

what is the difference between %_all and %_f tables

1 Answers  

The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.

7 Answers   SGS,

what type of testing u r doing?

2 Answers   Convergys,

While running the concurrent program we will get the status, we have to change the status. How it will be done.

2 Answers   Zensar,

what is repeting frame?

3 Answers   TCS,

Oder of firing triggers in form

7 Answers   Oracle, Zensar,