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)

Is SOB is attached with Business grp ?

2 Answers   Convergys,

---

If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?

4 Answers  

---

which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,

---

What is the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,

---

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1

25 Answers   IBM, Satyam,

---

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers  

---

Is there any limitations on responsibility assigned to a apps user?

6 Answers   ESS,

---

what are the steps to develop a new report?

7 Answers   Infotech, Satyam,

---

What are triggers?

3 Answers  

---

what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

1 Answers  

---

What is Value Set?

2 Answers   Accenture,

---

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,

---