Hello there,

can any one tell me whether we can generate a matrix report in oracle. I have some values in a table and I want a report in which these (rows) values will appear as columns

Here is the table structure.


Name Null? Type
------------------------------- -------- ----
LOOMNO VARCHAR2(10)
SHIFTNO VARCHAR2(10)
DATES DATE
REASON NUMBER(10)
TIMES NUMBER(10)
MM NUMBER(2)
YYYY NUMBER(4)
PERSON_MODIFIED VARCHAR2(50)
DATE_MODIFIED DATE

I want a report like :


loom no Reason1 reason2 reaon3
1 ******

2

3


----------------------------------------

in the above report reason1,2,3 are the values stored in column 'reason' and '******' is the sum of times for each reason value i.e. for reason1,2,3 etc.


thanks in advance

regards,

Anand