-
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
-
Any suggestions????
Thanks
-
Try with double quote.
ex:
SELECT ID "My ID", Name "EMP Name"
FROM EMP ;
I am sorry. This will not work.
-
Post a sample o/p that you wish to see.
svk
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|