Question

oracle 将字符型转换为数值型

在表A 中有字段a1为字符型char(1),如何将其转换为number(1)，表中字段a1含有记录.

Answer 1

select to_number('111') from dual; --111
select to_number('111.233','FM999990.000') from dual; --111.233

Answer 2

字符转化为数值：
to_number(a1)

Answer 3

使用内置函数to_number

Answer 4

to_number(a1)

Answer 5

to_number