有这样的数据处理varchar2 aaa;
varchar2 bbb;
varchar2 rate;
rate :=ROUND(TO_NUMBER(aaa)/TO_NUMBER(bbb),3)*100
aaa=1
bbb=1000
rate= .1
我想得到rate=0.1应该怎么处理啊?
varchar2 bbb;
varchar2 rate;
rate :=ROUND(TO_NUMBER(aaa)/TO_NUMBER(bbb),3)*100
aaa=1
bbb=1000
rate= .1
我想得到rate=0.1应该怎么处理啊?
N
----------
0.5
SQL> SQL> select to_char(0.5,'0.0') from dual;
TO_C
----
0.5
----
0.5SQL>