what is meant by lexical parameter



what is meant by lexical parameter..

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 This Answer Correct ?    15 Yes 0 No

Post New Answer

More Oracle Apps Technical Interview Questions

what are the different calculation columns available in reports?

1 Answers  


Explain what are the tables of auto invoice?

0 Answers  


Oder of firing triggers in form

7 Answers   Oracle, Zensar,


in one report using two layout models.if yes how to do

4 Answers   Covansys,


what is the defference between credit memo and debit memo

2 Answers  






where to define interorganization transaction charges and what are the different options?

0 Answers   Scan Steel,


Can u suggest me the best institute for Oracle apps Technical in Hyderabad?

16 Answers  


Who information?s?

2 Answers  


Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,


We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,


what is instead of trigger in where u will use?

2 Answers   TCS,


maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?

6 Answers   LG Soft,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)