with my_tab as (select 2700 col1 from dual union all
select 12500 col1 from dual union all
select 700 col1 from dual)
-- end of mimicking your data; USE SQL below:
select col1 / 1000
from my_tab;
COL1/1000
----------
2.7
12.5
.7
SQL> select to_char(n/1000,'90.9') n
from (
select 12500 n from dual union all
select 2700 n from dual union all
select 700 n from dual
)
/
N
-----
12.5
2.7
0.7
3 rows selected.
