Multiple SQL queries in one Report

Hi all,

I have a little problem, and if you have a solution please reply.

In an oracle Report I have 45 simmilar quries that look like this:

SELECT ALL something, COUNT(1)
FROM somewhere
WHERE something LIKE 'BSC01%'
GROUP BY something

Other 44 queries hav values from 'BSC02%' to 'BSC45'.

Now I would like to know is there any way to make only one query and the value 'BSC$$%' to receive from some PL/SQL or somethin else???

Thanks Received on Thu Mar 06 2003 - 18:32:02 CET