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)

what is the back ground program run while transferring data from OM to AR?

4 Answers   Qwest,

---

What is oracle soa suite?

0 Answers  

---

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers   IBM,

---

Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,

---

What is set function in sql .E.g.What is difference between union and union all

2 Answers   IBM, TCS,

---

what is repeting frame?

3 Answers   TCS,

---

what are the pl/sql tables

1 Answers   IBM,

---

q)what are the validations in sql*loader

0 Answers   Accenture,

---

Difference between Bind and Lexical parameters?

3 Answers  

---

in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers   Cap Gemini,

---

How to insert data into two tables using single control file?

3 Answers   Oracle, VTI,

---

What is request group

4 Answers   Accenture,

---