-
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
-
re: column
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
-
re
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!
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
|