DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: using pl/sql to format results! help!

  1. #1
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100
    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 :-)

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    use dbms_output to display results and SQL functions to format them

  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Can you be a little more specific?

    What, exactly, does the data look like now?

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  4. #4
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    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

  5. #5
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Uh, okay, but what did you mean by 'results are open or results are closed'? There is no such information here.

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  6. #6
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    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
  •  


Click Here to Expand Forum to Full Width