求助:oracle 查询问题

[dengying201]

在一个数据表里有一个字段是number型的,假设表名是table 字段名是num
有一个数据是5.00105000001909E17
用to_char(5.00105000001909E17)转化以后是 500105000001909000
我用两种方式去查询但是都得不到数据,查询方式如下:
select * from table where num=5.00105000001909E17

select * from table to_char(num)=500105000001909000

望高手解答!

[fangbintao]

select * from table where num=5.00105000001909E17 --> select * from table where num=500105000001909000

select * from table to_char(num)=500105000001909000 -->select * from table to_char(num)='500105000001909000'

[新鲜鱼排]

select * from table where num=5.00105000001909E17

select * from table where to_char(num)=500105000001909000

这两种方法都好用。

[叶涛网站推广优化]

select * from table where to_char(num)=500105000001909000

[多壮志]

你什么版本，怎么没有出现你的情况？我的是10g R2

[hezhudaozhai]

select * from table where num=5.00105000001909E17 --> select * from table where num=500105000001909000

select * from table to_char(num)=500105000001909000 -->select * from table to_char(num)='500105000001909000'

可以吧