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 |
How you will Diaplay the Company LOGO In report.Can anyone knows please give solution
Can u define DFF with in the DFF,How?
what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.
Form development process?
What are do's and dont's of Interface?
What is GLOBAL TEMPORARY TABLE and It's significance ?
what is item status? name the related table.
WHAT IS THE FORWARDREFERENCE IN PL/SQL?
Can you explain the difference between architecture followed in 10g & 11g?
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.
when we run payment batch what are the 3 concurrent programs?
Explain what are the tables of auto invoice?