Home » SQL & PL/SQL » SQL & PL/SQL » cross tabulation question
cross tabulation question [message #37308] Wed, 30 January 2002 08:09 Go to next message
Lee
Messages: 56
Registered: May 1999
Member
I need to do a cross tabulation without using DECODE. Is there a way to do this? Basically I have table :

Level Code Number St
1 A 25 AZ
1 B 20 AZ
2 A 15 HI
2 B 10 HI

Desired Output:

Level A B St
1 25 20 AZ
2 15 10 HI

I can't use Decode because there are many different Codes. Any help would be much appreciated. Thanks!

Report message to a moderator

Re: cross tabulation question [message #37310 is a reply to message #37308] Wed, 30 January 2002 08:21 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
see if this helps...
http://asktom.oracle.com/pls/ask/f?p=4950:8:115419::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1355765880641,

Report message to a moderator

Previous Topic: shared pool memory flush
Next Topic: default database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 09 16:31:26 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.