Answer Posted / sam

Bind references are used to replace a single value in SQL
or PL/SQL. Specifically, bind references may be used to
replace expressions in SELECT, WHERE, GROUP BY, ORDER BY,
HAVING,CONNECT BY, and START WITH clauses of queries.
Bind references may not be used in a FROM clause.
An example is:
SELECT ORDID,TOTAL
FROM ORD
WHERE CUSTID = :CUST

Lexical references are placeholders for text that you embed
in a SELECT statement, when you want the parameter to
substitute multiple values at runtime. You can use lexical
references to replace the clauses appearing after SELECT,
FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and
START WITH. You cannot make lexical references in PL/SQL.
Before you reference a lexical parameter in a query you
must have predefined the parameter and given it an initial
value.
An example is:
SELECT ORDID, TOTAL
FROM &ATABLE

what are the different transaction clauses in AR?

2054

---

Tell me how to find the custom directory in front end?

1054

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3573

---

what is pay run id ?

2127

---

List the types of flexfield?

990

---

Tell me where we find the status of order information?

1100

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2168

---

What are file in oracle.

2180

---

What do you understand by soa and what are the benefits of using this architecture?

1027

---

How can a process be deployed in soa?

1160

---

How to create a purchase order without a requisition?

1125

---

Which oracle apps version you are very confident in?

1175

---

Can u give the Documentation of Custom.pll in oracle apps

3420

---

is it possible to run the interface without using oracle apps?

1927

---

What is a flexfield? List out its types.

1109

---