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

Thread: SPOOL OUPTUT

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    Hi all,

    If I have an option

    set heading off


    and below is my output.

    DATA_TS 130 127 3 2.12
    INDX_TS 100 15 85 85.18
    ROLLBACK_TS 50 16 34 67.49
    SYSTEM 50 42 8 16.25
    TEMP_TS 0 0
    TOOLS 100 3 97 97.49


    What I am trying to get here is the column header say if
    I turn the heading off I will get:

    TOTAL MB USED MB FREE MB % FREE

    Please advise

    Thanks

  2. #2
    Join Date
    Jan 2002
    Posts
    474
    Any suggestions????

    Thanks

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Try with double quote.
    ex:
    SELECT ID "My ID", Name "EMP Name"
    FROM EMP ;

    I am sorry. This will not work.

  4. #4
    Join Date
    Jul 2000
    Posts
    521
    Post a sample o/p that you wish to see.
    svk

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You can use the format command

    COL tablspace_name FORMAT A30
    COL "TOTAL MB" FORMAT A5
    COL "USED MB" FORMAT A5
    COL "FREE MB" FORMAT A5
    COL "% FREE" FORMAT A5

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You can either use column alias in double quotes or use COLUMN command with HEADING option.

    Sanjay

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