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

How you will Diaplay the Company LOGO In report.Can anyone knows please give solution

8 Answers   TCS,


Can u define DFF with in the DFF,How?

1 Answers   Satyam,


what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.

3 Answers   Scan Steel,


Form development process?

1 Answers  


What are do's and dont's of Interface?

0 Answers  


What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,


what is item status? name the related table.

1 Answers   Scan Steel,


WHAT IS THE FORWARDREFERENCE IN PL/SQL?

4 Answers   IBM,


Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  


hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.

1 Answers   BirlaSoft,


when we run payment batch what are the 3 concurrent programs?

1 Answers   Genpact, Wipro,


Explain what are the tables of auto invoice?

0 Answers  


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)