Oracle Reports

From: Peter Hazelton <peterhazelton_at_hotmail.com>
Date: Thu, 17 Aug 2000 18:42:08 GMT
Message-Id: <10592.114883@fatcity.com>

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

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Thu Aug 17 2000 - 13:42:08 CDT