Re: Crosstab queries in oracle

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Sun, 25 Jul 1999 23:53:13 +0100
Message-ID: <7ni21r$dlm$1@news.inet.tele.dk>

There's a new feature CUBE in 8i (8.1) that you can use in the GROUP BY expression that will allow you to build a query for you matrix report directly.

HTH. Finn

Diablo <diabl_at_email.com> wrote in message news:932719723.361.79_at_news.remarQ.com...
> 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 Sun Jul 25 1999 - 17:53:13 CDT