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 Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,

---

what is pl/sql table and pl/sql records? what is the use of that?

3 Answers   Intelligroup,

---

In Per_all_people_f table what is the significance of '_f ' ?

6 Answers   HCL,

---

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

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 is the difference between character mode,bitmap mode

2 Answers   IBM, Sierra Atlantica,

---

Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?

4 Answers   Zensar,

---

suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?

3 Answers   Oracle,

---

In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,

---

define steps of assigning items to an organization.

1 Answers   Scan Steel,

---

can we pass bind variablein lexical parameter?

1 Answers   BirlaSoft,

---

how to enable Zoom function and steps?

1 Answers   Patni,

---