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.