D2K - what is lexical parameter in report? Explain benefits and usage of lexical parameter?

GeekInterview.com > Interview Questions > Oracle > D2K

Go To First | Previous Question | Next Question

D2K | Question 50 of 71

what is lexical parameter in report? Explain benefits and usage of lexical parameter?

Total Answers and Comments: 4

Last Update: February 22, 2008 Asked by: kundan_mca12

Sponsored Links

Best Rated Answer

—

Submitted by: devenar

You can create a lexical parameter(references) by entering an ampersand (&) followed immediately by the column or parameter name.
Lexical parameter are placeholders for text that you embed in a SELECT statement and at runtime the values are replaced according to the conditions(e.g if else etc).
You can use lexical references(parameters) to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.

Above answer was rated as good by the following members:
viveksis

May 06, 2007 08:47:48

Lavanya Chowdary

Member Since: May 2007 Contribution: 4

RE: what is lexical parameter in report? Explain benef...

Lexical parameters r used to provide the sql clauses at runtime .
these r used for adhoc queries if u r not known the condition at runtime at that time we can use lexical parameters.
generally these r useful in datawarehousing applications.
these can be used in all clauses of select stmts.

Is this answer useful? Yes | No

October 25, 2007 14:00:11

bharani

RE: what is lexical parameter in report? Explain benef...

Can anybody explain in detail. How to pass Column names dynamically in runtime?

Is this answer useful? Yes | No

November 19, 2007 01:23:08

devenar

Member Since: November 2007 Contribution: 3

RE: what is lexical parameter in report? Explain benef...

You can create a lexical parameter(references) by entering an ampersand (&) followed immediately by the column or parameter name.
Lexical parameter are placeholders for text that you embed in a SELECT statement and at runtime the values are replaced according to the conditions(e.g if else etc).
You can use lexical references(parameters) to replace the clauses appearing after SELECT FROM WHERE GROUP BY ORDER BY HAVING CONNECT BY and START WITH.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 22, 2008 06:15:07

jagadeesh9

Member Since: February 2008 Contribution: 27

RE: what is lexical parameter in report? Explain benefits and usage of lexical parameter?

Lexical P.M is used to pass string
& is there it is Lexical P.M.
we can use in FROM clause
we can't use in PL/SQL

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank