Crosstab with Oracle SqlPlus?
This is a discussion on Crosstab with Oracle SqlPlus? within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Here is specs about the cross-tab feature: http://www.comp.hkbu.edu.hk/docs/o/d...en.htm#1002566 > 1. Is it possible to install Discoverer on computer A ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 11:15 AM
| ||||
| ||||
 Re: Crosstab with Oracle SqlPlus? Here is specs about the cross-tab feature: http://www.comp.hkbu.edu.hk/docs/o/d...en.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/pro...rer/index.html http://www.virginia.edu/integratedsy...i/reports.html http://www.comp.hkbu.edu.hk/docs/o/d...272_01/toc.htm hope this helps george antonyliu2002@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@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.      |
 |
« How to add "reference calculation" columns in design tables?
|
Re-hire contractor API in Oracle HRMS »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 06:53 AM.
