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

difference b/w procedures&functions

2 Answers   Oracle, TCS,

---

In custom.pll what are the events we can Not write.

1 Answers  

---

How will you get the concurrent program output as email?

3 Answers   IBM, KPIT,

---

What is sca and how is it useful?

0 Answers  

---

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

---

---

what is aim methodolozy

1 Answers   Wipro,

---

Which oracle apps version you are very confident in?

0 Answers  

---

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,

---

What is menu.

2 Answers   Accenture,

---

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

2 Answers   Deloitte, Oracle,

---

How does accounting occured in Expense Reporting?

1 Answers   Sapient,

---

what are centralized and decentralized level of control of item attributes?

2 Answers   Scan Steel,

---