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