What is a lexical parameter in reports 6i

Lexical Parameter is denoted by a symbol &(Amphersend) and is used in WHERE_CLAUSE.
with the help of this parameter we can pass strings.

  3 Users have rated as useful.

  

Login to rate this answer.

Lexical parameters are used to substitute multiple values at runtime. It can be used in FROM TABLE NAME and in WHERE clause. Usually the lexical parameters are defined in After Parameter Report or in Before Report.  For example:

IF :P_DATE_FROM IS NOT NULL AND :P_DATE_TO IS NOT NULL THEN
      :P_DATE := 'AND  trunc(ccchv.transaction_costed_date) BETWEEN :P_DATE_FROM AND :P_DATE_TO';
ELSE IF
      :P_DATE_FROM IS NOT NULL AND :P_DATE_TO IS NULL THEN
      :P_DATE := 'AND  trunc(ccchv.transaction_costed_date) BETWEEN :P_DATE_FROM AND SYSDATE';
ELSE
      :P_DATE := 'AND 1=1';
END IF;