Re: Crosstab with Oracle SqlPlus?

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 Mon Aug 28 2006 - 21:08:22 CDT