poonamyadav

 Profile Answers by poonamyadav 

• May 31st, 2008

 

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

mailsudhirn

 Profile Answers by mailsudhirn 

• Jun 4th, 2008

 

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;