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 package procedure used for invoke sql plus from sql forms ?
What do you mean by a pop-up window ?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
What is the built_in routine used to count the no of rows in a group?
Is it possible to execute a dynamic sql from forms?
What are the built_ins used the display the LOV?
can my report have different layouts
What is a radio Group?
what is latest version in reports
How do you trap the error in forms 3.0 ?
How to create placeholder columns?
Explain about stacked canvas views?