-
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
Anand Halkunde
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|