Answer / jay

Bind parameters are used to substitute one value at runtime
for evaluation and are identified by a preceding ‘:’. An
example of a bind parameter in a select statement is
provided below, where :P_EMP is the bind parameter
reference.

Example:
select *
from emp
where emp.name = :P_EMP;

Answer / sridhars.s

->there are denoted by columns
->it accepts single automic value
->bind parameters can be included in lexical parameter
->there parameters are denoted by ':'
exp: :num

What is the difference between base table and multi-org table?

3 Answers   Infosys,

---

IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?

7 Answers   Accenture,

---

in procedure how to return a value

4 Answers  

---

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

1 Answers   Oracle,

---

What is the package?

2 Answers  

---

whats the use of after parameter form and before report?

2 Answers   IBM,

---

In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,

---

What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,

---

mention the interface tables for item open interface and open transaction interface and also their respective production tables.

1 Answers   Scan Steel,

---

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,

---

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 the use of format trigger?a

3 Answers  

---