Hi all,
select 100,200.2 from dual;
result is as expected:
100 200.2
But result needed:
100.00 200.20
...and they have to be of type number. Maybe it's very simple task but i was unable to solve it...
I tried with Format mask but no effect:
Example:
select to_number('1000','FM999999999990D00') res from dual;
result:
1000
Any ideas?
Version: 11g
Thanks in advance,
Bahchevanov.