select cast(0 as NUMBER(15,3)) as N06,n06 from table
这句话里n06是有数据的,但cast(0 as NUMBER(15,3)) as N06转变类型后就没数据了,n06的数据类型就是NUMBER(15,3),而且数据也是整数,请大家帮助,我想cast来实现,显示数据。
这句话里n06是有数据的,但cast(0 as NUMBER(15,3)) as N06转变类型后就没数据了,n06的数据类型就是NUMBER(15,3),而且数据也是整数,请大家帮助,我想cast来实现,显示数据。
如果要转换类型可以to_date,to_char,to_number来转啊
case when nvl(n06,0) = 0 then
0
else
trunc(n06,3)
end as N06,
n06
from table