-
Can We Format Number Output in SQLD?
Hi Folks,
We are using 11.1.0.7 Standard Edition on Linux CentOS release 5.4 here.
I am used to using sqlplus, but now I'm trying to use SQLDeveloper. Heh. But I don't know how to tell SQLD to format numeric output.
-- with this query:
select s.USERNAME,
sum(p.pga_used_mem / 1024576) as pga_mgs_used
from v$process p, v$session s
where p.addr=s.paddr
and s.username is not null
group by s.username
order by s.username;
-- I get this:
CLINICA 1.92638711037541382972078206009119870073
-- and with this:
select s.username,
round(sum(p.pga_used_mem / 1024576)) as pga_mgs_used
from v$process p, v$session s
where p.addr=s.paddr
and s.username is not null
group by s.username order by s.username;
-- I get this:
CLINICA 2
-- but what I want is this:
CLINICA 1.93
It's easy in sqlplus, all you have to do is type:
column pga_mgs_used format 999.99
And then run your query. Can we do something equivalent in SQLD?
Thanks in advance for any advice.
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
|