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 are the built-ins used for processing rows?
Does a Before form trigger fire when the parameter form is suppressed.
a text item is there what r the different types of triggers associated with it
What is the built_in routine used to count the no of rows in a group?
How to change maximise or minimise the window in forms
Can a property clause itself be based on a property clause?
how will the report recognize the parameter
What is the difference between object embedding & linking in Oracle forms?
Identify package function from the following ?
What is a Query Record Group?
What are the unrestricted procedures used to change the popup screen position during run time ?
What are the various methods of performing a calculation in a report ?