Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle Reports
I have a parameter set up on my report. Call it :P_TEST_NUM.
My SQL query will be:
SELECT TEST_NUM
from TABLE
where TEST_NUM = :P_TEST_NUM
I want this parameter to accept several different numbers such as 1234, 1245, 1267 etc. I want this so that we don't have to run the report 20 times for 20 different numbers, we just paste in a list of numbers and the report runs for that list.
Can this be done? If so, how and what is the syntax??
Thanks
Peter
![]() |
![]() |