Oracle cube/crosstab query
Hi, I am a bit rusty on SQL and have the following problem.
I have a table ObjectData that contains the following fields:
For every ObjId there is a set of ObjAttribute 10-15 with corresponding ObjValue. The ObjCategory determins the set of ObjAttribute
Is there a way of making an SQL statement (oracle 9i) that gives the output as columns?
ObjAttribute can be hardcoded in the query if necessary, as the will not change and the attribute names are known
Output should be like this (showing column names)
Thanks in advance
ObjID ObjCategory Attribute1 Attribute2 Attribute3