Re: Crosstab with Oracle SqlPlus?

Here is specs about the cross-tab feature:

http://www.comp.hkbu.edu.hk/docs/o/dl/bi/B10272_01/2screen.htm#1002566

> 1. Is it possible to install Discoverer on computer A and hook it up
> with a data source on computer B?

yes its stand-alone and uses Oracle's server

> 2. Is it drag-and-drop kind of thing like Business Object?

its more of a GUI based report building tool, much like a super enhanced
spreadsheet with querying, etc....

Look here for more about Oracle's Discoverer:

http://www.oracle.com/technology/products/discoverer/index.html http://www.virginia.edu/integratedsystem/howdoi/reports.html

http://www.comp.hkbu.edu.hk/docs/o/dl/bi/B10272_01/toc.htm

hope this helps

george

antonyliu2002_at_yahoo.com wrote:
> Hey, George,
>
> Do you mind giving me more info about Oracle Discoverer?
>
> My questions are here:
>
> 1. Is it possible to install Discoverer on computer A and hook it up
> with a data source on computer B?
>
> 2. Is it drag-and-drop kind of thing like Business Object?
>
> If your answer to both questions is 'Yes', then that might be the kind
> of reporting tool my boss is looking for.
>
> Thanks.
>
>
> George Lewycky wrote:
> > Another option is Oracle's Discoverer has this feature built into it
> > and its easy to design
> >
> > George
> >
> > antonyliu2002_at_yahoo.com wrote:
> > > OK, I know this has been asked many times. I've done a google search,
> > > but but not figure out.
> > >
> > > I have a very simple table of student information in a Oracle database
> > > like below, where STU_ID is student id and COLL_CD is college code and
> > > CLS_LEVEL is class level.
> > >
> > > STU_ID COLL_CD CLS_LEVEL
> > > 123 KV 1U
> > > 234 KV 1U
> > > 345 KY 1U
> > > 456 KN 1G
> > > 567 KP 1L
> > > 678 KV 1U
> > > 789 KY 1G
> > > 890 KY 1G
> > > 901 KY 1U
> > > 911 KP 1V
> > > 912 KV 1L
> > > 913 KN 1G
> > > 915 KP 1U
> > >
> > > I would like to count and list the number of students of each class
> > > level in each college like so:
> > >
> > > COLL_CD 1U 1G 1L 1V
> > > KV 23 2 0 0
> > > KY 9 16 88 1
> > > KN 13 45 55 0
> > > KP 0 0 61 18
> > >
> > > I know I can do
> > >
> > > Select count(*) from T_STUDENT where COLL_CD='KV' and CLS_LEVEL='1U'
> > >
> > > one after another.
> > >
> > > But can I get this crosstab in a single SQL query with SqlPlus?
> > >
> > > Thanks.
Received on Tue Aug 29 2006 - 15:37:52 CDT