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 |
what are the different calculation columns available in reports?
Explain what are the tables of auto invoice?
Oder of firing triggers in form
in one report using two layout models.if yes how to do
what is the defference between credit memo and debit memo
where to define interorganization transaction charges and what are the different options?
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
Who information?s?
Steps for DFF registration
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?
what is instead of trigger in where u will use?
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?