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)

can we get profile values in report without using user exists is it possible how?

0 Answers   Cap Gemini,

---

How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,

---

WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  

---

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

0 Answers  

---

What is oracle soa suite and what are its different components?

0 Answers  

---

how to initialize applications?

2 Answers  

---

List the various types of value set.

0 Answers  

---

what is meant by Table space?

2 Answers  

---

what type of testing u r doing?

2 Answers   Convergys,

---

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,

---

Can functions be overloaded ?

2 Answers  

---