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 |
Does a grouping done for objects in the layout editor affect the grouping done in the datamodel editor?
What is the difference between BPA AND Contract What are documents and test cases u followed
What are the various methods of performing a calculation in a report ?
what u write in Ctl file
What is difference between open_form and call_form?
What is the built-in used for showing lov at runtime?
What does TKPROF stand for?
What is a Navigable item?
While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False.
List the different types of columns in oracle reports.
What is the use of hidden column?
While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not resolve the connect identifier specified what are the steps to solve this problem?