Yeah, I know, with Access also, I can do such a query but, in my case, I
have to return it directly from Oracle to a web page through ISAPI dll.. If
I cant do it from a simple query, gotta build my own crosstab conversion
procedure..
BRENT DOUGLAS wrote in message <37971d22_at_rpc1285.daytonoh.ncr.com>...
>have you considered a 3rd party solution? we use BusinessObjects, and this
>makes crosstab reporting very easy.....
>
>just an idea....
>
>brent
>
>>Does anyone know hot to make access-like crosstab query in oracle SQL?
>>
>>For ex:
>>Select city,name,count(*) from people group by city,name
>>
>
>
Received on Fri Jul 23 1999 - 03:47:03 CDT
