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 used to get and set lov properties during run-time?
What is summary column in Oracle Reports ?
how to call forms in parametar forms
How do you trap the error in forms 3.0 ?
What are the two panes that Appear in the design time pl/sql ?
How many types of trigger can be used in a table at a time ?
What are the triggers associated with the image item?
How i get the client machine Ip address through developer 2000 forms, if you are running three tier architech.
how we can validate the run-time parameters in reports 6i
how to eliminate duplictes in column except group and section?
What are the built-in used for getting cell values?
Is it possible to have multiple layouts in a report?