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 |
What is the built_in routine used to count the no of rows in a group?
what is the difference between oracle reports 6i and oracle reports 10g? give atleast 10 differences? (plz give the answer vvvvvvvvvvv.urgent)
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
how to load data into base tables
What are the different types of Delete details we can establish in Master-Details?
What are the different default triggers created when Master Deletes Property is set to isolated?
Name the different triggers supported by oracle reports and their firing order.
if some data is not transfered where it will get stored
What is a Non Query Record Group?
difference between place holder and formula column
3 Answers Cognizant, IBM, Microsoft,
What is the difference between NAME_IN and COPY ?
How do you reference a parameter indirectly?