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 multi org structure?

3 Answers   Covansys, TCS,

---

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

3 Answers   Satyam,

---

Presently u are working in which version?

4 Answers   Accenture,

---

What is an Index , Types od index why we are use index.

2 Answers   IBM,

---

where the accounting related data is stored ?

2 Answers  

---

can u explain which situation automonus transaction is used

2 Answers  

---

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers  

---

WHAT IS THE FORWARDREFERENCE IN PL/SQL?

4 Answers   IBM,

---

please send me forms, xml pulisher questions,answers

0 Answers   Zensar,

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---

What is responsibility and how u attach

5 Answers   Accenture,

---

Can you differentiate between mediator and osb?

0 Answers  

---