Answer / jay

Lexical parameters are used to substitute multiple values
at runtime and are identified by a preceding ‘&’. Lexical s
can consist of as little a one line where clause to an
entire select statement

Lexical parameter is a feature used for building a dynamic
query.

Example: An example of a lexical parameter usage in a
select statement is as follows

select *
from emp
where &L_EMP; (Report can assign a value as :L_EMP:=
emp.dept = 20 and salary > 20000)

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

0 Answers  

---

Difference between set of books id and ledger id in r12 ?

1 Answers   TCS,

---

can we write sql statement in Format trigger?

4 Answers  

---

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers  

---

Types of cursors?

3 Answers  

---

in ap_terms table what data will be stored

1 Answers  

---

tell me the scenarios of between pages in reports

5 Answers  

---

What is cursor?

3 Answers  

---

Attribute data types?

2 Answers  

---

How to link modules in apps

3 Answers   Zensar,

---

How do u customize the Reports?

1 Answers  

---

Can function be overload?

4 Answers  

---