Printable View
s1 s2 s3 s4
Total Open 999 999 999 999
Total Closed 999 999 999 999
Grand Total 999 999 999 999
above is the out put expected from a query. s1-s4 is from a single column with four severity levels in that column it has been taken apart to retrive the information
now how would you write this in pl/sql so that you can get the total in the s1 field in the s1 column where requests are open and the total in the s1 field where requests are closed?
thanks your help is appreciated :-)
use dbms_output to display results and SQL functions to format them
Can you be a little more specific?
What, exactly, does the data look like now?
- Chris
issue
-------------------------
2 - Serious
3 - Moderate
3 - Moderate
2 - Serious
3 - Moderate
4 - Tolerable
3 - Moderate
2 - Serious
3 - Moderate
4 - Tolerable
4 - Tolerable
Uh, okay, but what did you mean by 'results are open or results are closed'? There is no such information here.
- Chris
issue defects
-------------------------
2 - Serious open
3 - Moderate closed
3 - Moderate open
2 - Serious closed
3 - Moderate closed
4 - Tolerable open
3 - Moderate open
2 - Serious closed
3 - Moderate closed
4 - Tolerable open
4 - Tolerable open
there is another column called defects that maps accross as stated thanks chris!