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)

how to move the one file from one instance to another instance?and ur scripts also?

1 Answers   KPMG,

---

What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,

---

How do you register report in oracle apps?

0 Answers  

---

in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?

1 Answers   Oracle,

---

Exception Handilings?

1 Answers  

---

how many groups we can create for query?

3 Answers  

---

which API to return the parameters & valuesets etc

1 Answers   GE, TCS,

---

what is multi org structure?

3 Answers   Covansys, TCS,

---

In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,

---

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

25 Answers   IBM, Satyam,

---

What r the type Models in the system parameters of the report?

1 Answers  

---

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

4 Answers  

---