What is lexical parameter ?
Answers were Sorted based on User's Feedback
Answer / anil kumar karasi
Lexical parameter is a condition (where clause) given at
runtime to generate the report on that condition. The '&'
symbol will preceed the where clause condition.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / deepak muduli
Lexical parameters can dynamically replace clauses in the
Select statement in the data model and even the whole
select statement. It replaces any part of a SELECT
statement, such as column names, the FROM clause, the WHERE
clause, the ORDER BY clause. To create a lexical reference
in a query, prefix the parameter name with an ampersand (&)
| Is This Answer Correct ? | 8 Yes | 3 No |
how report can be generated if we have the database designed in oracle 10g?
Can a property clause itself be based on a property clause?
What are the two phases of block coordination?
What are the built_ins used the display the LOV?
How can a break order be created on a column in an existing group?
What are the two ways by which data can be generated for a parameter's Using static values?
What are the types of TRIGGERS ?
What are the built-ins used for processing rows?
Can u explain me the Restricted and unrestricted procedure in Forms And reports and example as well ??
What is the usage of the Flex mode in Layout Editor ?
What is a window?
What is an user exit used for?