| |
GeekInterview.com > Interview Questions > Oracle Apps > D2K
| Print | |
Question: What is a lexical parameter in reports 6i
|
| June 06, 2008 06:50:37 |
#2 |
| mailsudhirn |
Member Since: June 2008 Total Comments: 1 |
RE: What is a lexical parameter in reports 6i
|
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; |
| |
Back To Question | |
