Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Silly matrix report problem
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 4Received on Thu Feb 08 2001 - 17:13:04 CST