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 difference between setting up of parameters in reports 2.0 reports ?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
How to call a report from Forms?
How to create Drill down report?
What is the use of Validation triggers in Reports?
suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?
What are the type of triggers available in Oracle Reports ?
3 Answers Convergys, IBM, KPIT, Oracle, TCS,
What are the different types of Package Procedure ?
What is the difference between Anchoring Object and Enclosing Objects ?
how to send sms to mobile phone from oracle forms.
what are difference between post database commit and post-form commit?
what is the exact navigation to create a radio button in form6i? can i create the radio button in report6i?