I need help with structuring a table
This is the scenario, I have a table that goes like this
<DATE><STATUS><COUNT_STATUS>
#####1 PASS 1
#####1 FAIL 2
#####1 KILLED 10
#####2 PASS 2
#####2 FAIL 12
#####3 KILLED 9
Is there a way to write a query to change it to this which is grouped by date and parses all those rows into columns and leaves the count @ zero or blank if there is no count present for that Status.
<DATE><PASS><c><FAIL><c><KILLED><c>
#####1 PASS 1 FAIL 2 KILLED 10
#####2 PASS 2 FAIL 12
#####3 KILLED 9
Thanks.
Subject
Written By
Posted
I need help with structuring a table
July 29, 2006 08:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.