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 |
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
How can a text file be attached to a report while creating in the report writer?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
When is PRE-QUERY trigger executed ?
how to pass 2 parameters from one form to other in oracle applications?
What is the use of Validation triggers in Reports?
How many Flexfields are there in AR and what are they ?
Any attempt to navigate programatically to disabled form in a call_form stack is allowed?
HI GURUS, WHAT IS THE PURPOSE OF LEXICAL PARAMETER IN REPORT DEVELOPMENT.
What is the difference between setting up of parameters in reports 2.0 reports ?
What are the two panes that Appear in the design time pl/sql ?
difference between place holder and formula column
3 Answers Cognizant, IBM, Microsoft,