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)

where do u specify in org_id?

2 Answers  

---

What do you understand by a set of books?

0 Answers  

---

In unix Schell sript what is very 1st line to be wriiten .

2 Answers   IBM,

---

Difference between triggers and procedures?

2 Answers  

---

I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,

---

---

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

2 Answers   Accenture,

---

What repots or concurrent program run to transfer data from Inventory to GL.

5 Answers   IBM, iGate,

---

oracle apps architecture

1 Answers   TCS,

---

how to change the logo in template dynamically?

2 Answers   Sierra Atlantica,

---

Registering parametric report?

1 Answers  

---

How do u identity its name of report?

3 Answers  

---

How can we import the data into a database using sql * loader?

0 Answers  

---