Answer Posted / 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 View All Answers
do you know is it possible to run the interface without using oracle apps?
What is oracle soa suite?
What is oracle soa suite and what are its different components?
What are the different components of soa suite?
How many schemas we have? how many you have used?
what are the balancing segments in AR?
What is the concept of soa governance?
How is choreography different from orchestration?
tell me the scenarios of the independent in reports
What are the different components you should consider while defining a responsibility in oracle apps?
Which oracle apps version you are very confident in?
can we get profile values in report without using user exists is it possible how?
How do you register report in oracle apps?
what is the difference between request group and request security in oracle apps?
q)what are the validations in sql*loader