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 are the sql clauses supported in the link property sheet?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
i am writing a query select EmpNo from Emp how can i call in after parameter form
Can a sigle canvas be used by different blocks ?
difference between repeating frame and frame
What is the difference between boiler plat images and image items?
What is Post-Block?
What is the maximum size of a form ?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What built-in is used for changing the properties of the window dynamically?
What do you understand by oracle forms?
Can you have more than one content canvas view attached with a window?