Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Silly matrix report problem

Silly matrix report problem

From: Mark Styles <news_at_lambic.co.uk>
Date: Thu, 08 Feb 2001 18:13:04 -0500
Message-ID: <fm968tk60o5gtacj3a53bnjb4vt13c6sr0@4ax.com>

Hi,

I'd like to create a matrix report from a table like:

CREATE TABLE fred
(

	X-labels		VARCHAR2(5)

,Y-labels VARCHAR2(5)
,value NUMBER

);

I don't have the luxury of Oracle Reports or any other good reporting tool, I just have SQL. I could do it in PL/SQL, but I'm hoping there is a way in straight SQL.

data example:

X-labels		Y-labels		value
fred		rocks		1
wilma		rocks		2
barney		stones		4
fred		stones		3

would produce

	fred	wilma	barney
rocks	1	2		
stones	3		4
Received on Thu Feb 08 2001 - 17:13:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US