|
| Total Answers and Comments: 3 |
Last Update: February 25, 2009 Asked by: pragya.vyas |
|
| | |
|
Submitted by: Raghu2008 You can use the lexical parameters at From clause but you have to use lexical parameter as given below.
SELECT 'last_name' client_last_name, 'first_name' client_first_name, 'mailing_address1' mailing_address, 'city' city
FROM dual WHERE 1=2 &RGROUP1
In above query I have used 2 lexical parameters and while calling the above report pass the &RGOUP1 values using the below statement.
:RGROUP1 := 'UNION
SELECT 'last_name' client_last_name, 'first_name' client_first_name, 'mailing_address1' mailing_address, 'city' city
FROM emp_det'Using the above method you can generate the dynamic query in the report.
Thanks, Raghu.
Above answer was rated as good by the following members: nalinbit | Go To Top
|