SQL & PL/SQL

Hi all,

I have data like this, so i need to convert it into actual number (0.000004 ).

I used to to_char(order_rate) and i need to use round function this as well

how to convert scientific notation to number in oracle sql?
Note: we need to print 8 digits after the decimal point as well.

Oracle 19c

CREATE OR REPLACE FORCE VIEW xxc_test(order_rate)
as
select 1/250000 order_rate from dual
union all
select 1/3.675415  from dual;

select * from xxc_test 

Output
========
4E-5
0.272317790199082