oracle 9.2版本数据库,执行一条SQL语句
select wear from pm_bompr where pkid=418
显示如下:
wear
1 0.05
执行下面这条
select to_char(wear) from pm_bompr where pkid=418
显示如下:
wear
1 .050000000000000003其中,wear字段类型为number,没有加精度限制,记录的值为0.05何因?
select wear from pm_bompr where pkid=418
显示如下:
wear
1 0.05
执行下面这条
select to_char(wear) from pm_bompr where pkid=418
显示如下:
wear
1 .050000000000000003其中,wear字段类型为number,没有加精度限制,记录的值为0.05何因?
sql>select wear from pm_bompr where pkid=418