| format column problem [message #521692] |
Thu, 01 September 2011 02:50  |
 |
hanner
Messages: 90
Registered: August 2011
Location: at HOME
|
Member |
|
|
SQL> col sid for a80
SQL>
SQL> select round(sofar*100/totalwork,2), sid from v$session_Longops where time_remaining > 0;
ROUND(SOFAR*100/TOTALWORK,2) SID
---------------------------- ----------
.05 ##########
80.09 ##########
hi,
i am learning how to format my query output. But i kept on getting this ##### ... I tried running without the [col sid for a80' and i manage to get the value. I seen the rest doing as the same as me but i dun seem to get it. please further advice.
|
|
|
|
| Re: format column problem [message #521693 is a reply to message #521692] |
Thu, 01 September 2011 02:57  |
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
|
Senior Member |
|
|
That's odd, what versions are you running?
SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 1 08:56:12 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production
scott@orcl> select round(sofar*100/totalwork,2), sid from v$session_Longops where time_remaining > 0;
ROUND(SOFAR*100/TOTALWORK,2) SID
---------------------------- ----------
14.8 1503
38.23 210
11.47 4126
61.87 2444
2.41 5368
91.8 686
63.75 4678
37 365
44.48 2676
37.86 3907
6.1 4910
61.51 862
66.93 6174
58.24 2616
76.38 2008
62.97 1840
76.94 2906
30.13 863
41.82 300
66.66 3522
14.71 4181
61.8 2563
65.95 1585
5.06 3088
58.83 3584
25 rows selected.
Elapsed: 00:00:00.26 |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
