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
What is instead of trigger in where we will use?
how can i print random rows in plsql table
Do you know what are user profiles in apps. Any examples you can give?
tell me the scenarios of the independent in reports
Do you know where we can check the status of po?
How can you achieve loose coupling in soa framework?
What are the different components you should consider while defining a responsibility in oracle apps?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
do you know is it possible to run the interface without using oracle apps?
In sequence i want to 11 and 15th values how we will write?
What are the different components of soa suite?
In oracle application how do you debug or trace errors?
what are the prerequisites for costing transactions?
can we get profile values in report without using user exists is it possible how?
How is choreography different from orchestration?
