oraclehelps.com

Lexical references are placeholders for text that you embed in a SELECT statement. Use Lexical reference when you want the parameter to substitute multiple values at runtime. You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.

Lexical parameters are used to substitute multiple values at runtime and are identified by a preceding ‘&’. Lexical s can consist of as little a one line where clause to an entire select statement

Lexical Parameters are used to execute query dynamically.

Example:

Select * from my_table &where.

This entry was posted on Thursday, April 9th, 2009 at 5:06 am and is filed under Oracle Report. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.