Re: Cross tab with non-numeric information

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 17 Mar 2006 20:01:03 +0100
Message-ID: <441b076e$0$21093$626a54ce@news.free.fr>

"NancyASAP" <nancyasap_at_aol.com> a écrit dans le message de news: 1142621167.933083.202160_at_i39g2000cwa.googlegroups.com...
|I need to cross tab some information that looks like this:
|
| UserPermission UserGroup Enabled
| 100 1 Y
| 100 2 N
| 100 3 Y
| 200 1 Y
| 200 2 Y
| 200 3 N
| etc.
|
| Number of usergroups is fixed. What I would like to see as output is
| this:
|
| UserPermission Group1 Group2 Group3
| 100 Y N Y
| 200 Y Y N
|
| Can anyone give me a clue how to do this? I've been looking at analytic
| functions like CUBE, but they seem to always assume that you are
| rolling up numeric values, rather than moving an actual column value
| (Enabled) into the cube.
|
| Thanks for any help on this.
| Nancyasap
|

CUBE is not an analytic function.
Pivot is the keyword you have to search for For instance on http://asktom.oracle.com

Regards
Michel Cadot Received on Fri Mar 17 2006 - 13:01:03 CST