Hello,

Is there a Windows GUI pivot table tool that has the fuctionallity of
pivot tables in Access (user can choose which fields to use in the
pivot table, filter the data etc.)? I could of course connect Access
to Oracle but this would mean that Access would read a huge amount of
data from Oracle and changes in the pivot table would be very slow.
I'd prefer a tool that looks at the fields the user actually needs and
creates a corresponding query doing all the grouping on Oracle. Thus
as little computing would be done on the client's computer as possible
and as little data would be transferd to the client.

Does anybody know such a tool? Best freeware? We could of course
programme it ourselves but if we had not have to do that work I'd be
happy.

I know that 11g offers some pivot functionality but that is not
comfortable enough for my collegues who are not experienced with sql.

Thanks and best

Hans

"Hans Mayr" <mayr1972 (AT) gmx (DOT) de> schreef in bericht
news:4e80a1d7-6004-4fea-aeb6-acff4d43e657 (AT) s19g2000prg (DOT) googlegroups.com...
Oracle Discoverer?

Shakespeare

"Hans Mayr" <mayr1972 (AT) gmx (DOT) de> schreef in bericht
news:4e80a1d7-6004-4fea-aeb6-acff4d43e657 (AT) s19g2000prg (DOT) googlegroups.com...
Oracle Discoverer?

Shakespeare

"Hans Mayr" <mayr1972 (AT) gmx (DOT) de> schreef in bericht
news:4e80a1d7-6004-4fea-aeb6-acff4d43e657 (AT) s19g2000prg (DOT) googlegroups.com...
Oracle Discoverer?

Shakespeare

"Hans Mayr" <mayr1972 (AT) gmx (DOT) de> schreef in bericht
news:4e80a1d7-6004-4fea-aeb6-acff4d43e657 (AT) s19g2000prg (DOT) googlegroups.com...
Oracle Discoverer?

Shakespeare

Hi Shakespear,

Thanks for the fast response. I have never worked with this. This may
be a dummy question, but I have been surfing through Oracle's website
for some 20 minutes now without finding out if I can download the
Discoverer or which package I have to download. Neither could I find a
clear answer if this is as free as the SQL Developer. Could you please
help me again?

Thanks,

Hans

Hi Shakespear,

Thanks for the fast response. I have never worked with this. This may
be a dummy question, but I have been surfing through Oracle's website
for some 20 minutes now without finding out if I can download the
Discoverer or which package I have to download. Neither could I find a
clear answer if this is as free as the SQL Developer. Could you please
help me again?

Thanks,

Hans

Hi Shakespear,

Thanks for the fast response. I have never worked with this. This may
be a dummy question, but I have been surfing through Oracle's website
for some 20 minutes now without finding out if I can download the
Discoverer or which package I have to download. Neither could I find a
clear answer if this is as free as the SQL Developer. Could you please
help me again?

Thanks,

Hans

Hi Shakespear,

Thanks for the fast response. I have never worked with this. This may
be a dummy question, but I have been surfing through Oracle's website
for some 20 minutes now without finding out if I can download the
Discoverer or which package I have to download. Neither could I find a
clear answer if this is as free as the SQL Developer. Could you please
help me again?

Thanks,

Hans

"Hans Mayr" <mayr1972 (AT) gmx (DOT) de> schreef in bericht
news:e99f3f3e-0359-4cd2-97b1-827a1488c0c2 (AT) m3g2000hsc (DOT) googlegroups.com...
Discoverer comes with Application Server. I think you need a license for AS.

Shakespeare