oracle中数字保留几位小数的问题

最新推荐文章于 2025-05-28 09:13:06 发布

weixin_34401479

最新推荐文章于 2025-05-28 09:13:06 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/fly-boy/p/8516426.html

本文介绍了一种使用SQL从数据库中提取金额并将其转换为带有金额单位（如分、角、圆等）的字符串的方法。重点解决了整数金额转换时小数点后0被忽略的问题，并提供了一个实用的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

需求:
#将数字填充到对应金额单中
select substr(b.payMoney,length(b.payMoney),1) 分,
substr(b.payMoney,length(b.payMoney)-1,1) 角,
case when length(b.payMoney)-3 <=0 then ''
  else substr(b.payMoney,length(b.payMoney)-3,1) 
    end 圆,
case when length(b.payMoney)-4 <=0 then ''
  else substr(b.payMoney,length(b.payMoney)-4,1) 
    end 拾,
    case when length(b.payMoney)-5 <=0 then ''
  else substr(b.payMoney,length(b.payMoney)-5,1) 
    end 百,
    case when length(b.payMoney)-6 <=0 then ''
  else substr(b.payMoney,length(b.payMoney)-6,1) 
    end 千,
    case when length(b.payMoney)-7 <=0 then ''
  else substr(b.payMoney,length(b.payMoney)-7,1) 
    end 万,
    case when length(b.payMoney)-8 <=0 then ''
  else substr(b.payMoney,length(b.payMoney)-8,1) 
    end 十万,
    case when length(b.payMoney)-9 <=0 then ''
  else substr(b.payMoney,length(b.payMoney)-9,1) 
    end 百万,
    case when length(b.payMoney)-10 <=0 then ''
  e end 亿
   from dual;
   lse substr(b.payMoney,length(b.payMoney)-10,1) 
    end 千万,
    case when length(b.payMoney)-11 <=0 then ''
  else substr(b.payMoney,length(b.payMoney)-11,1)