Lavanya Chowdary

 Profile Answers by Lavanya Chowdary 

• May 6th, 2007

 

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.

bharani

• Oct 25th, 2007

 

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

devenar

 Profile Answers by devenar 

• Nov 19th, 2007

 

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.

jagadeesh9

 Profile Answers by jagadeesh9 Questions by jagadeesh9

• Feb 22nd, 2008

 

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