Re: Multiple SQL queries in one Report
From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 07 Mar 2003 01:53:56 GMT
Message-ID: <Xns9336B61677C1ASunnySD_at_68.6.19.6>
Date: Fri, 07 Mar 2003 01:53:56 GMT
Message-ID: <Xns9336B61677C1ASunnySD_at_68.6.19.6>
vb_bip_at_yahoo.com (wacky) wrote in
news:8ec7a409.0303060101.55d3bdd8_at_posting.google.com:
> 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
>
yes there is a way.
HTH & YMMV HAND! Received on Fri Mar 07 2003 - 02:53:56 CET