oracle中关于截取NUMBER型整数和小数的问题现有A=24.00000,要取整数:substr(a,instr(a,'.0',1,1)+1)则A=24 若A=0.24,再用substr()截取就得A=.24,若用to_char(a,'99990.00')则A=0.24,此时若A=24.00000的话,则A=24.00现在是想
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 12:41:08
![oracle中关于截取NUMBER型整数和小数的问题现有A=24.00000,要取整数:substr(a,instr(a,'.0',1,1)+1)则A=24 若A=0.24,再用substr()截取就得A=.24,若用to_char(a,'99990.00')则A=0.24,此时若A=24.00000的话,则A=24.00现在是想](/uploads/image/z/7557849-9-9.jpg?t=oracle%E4%B8%AD%E5%85%B3%E4%BA%8E%E6%88%AA%E5%8F%96NUMBER%E5%9E%8B%E6%95%B4%E6%95%B0%E5%92%8C%E5%B0%8F%E6%95%B0%E7%9A%84%E9%97%AE%E9%A2%98%E7%8E%B0%E6%9C%89A%3D24.00000%2C%E8%A6%81%E5%8F%96%E6%95%B4%E6%95%B0%EF%BC%9Asubstr%28a%2Cinstr%28a%2C%27.0%27%2C1%2C1%29%2B1%29%E5%88%99A%3D24+%E8%8B%A5A%3D0.24%2C%E5%86%8D%E7%94%A8substr%28%29%E6%88%AA%E5%8F%96%E5%B0%B1%E5%BE%97A%3D.24%2C%E8%8B%A5%E7%94%A8to_char%28a%2C%2799990.00%27%29%E5%88%99A%3D0.24%2C%E6%AD%A4%E6%97%B6%E8%8B%A5A%3D24.00000%E7%9A%84%E8%AF%9D%2C%E5%88%99A%3D24.00%E7%8E%B0%E5%9C%A8%E6%98%AF%E6%83%B3)
xRN@qB0qmJJ-iw0( B P1Fůae/xWs9dLLQ1-{t8~)=.llmf06'JҪZ4p$у!̹MhPJvo_
!jtx#]Zz~ģHʶ'8lKp8d ݑʓCMqKr<j;44