ORACLE数据库前导0的问题

最新推荐文章于 2024-06-18 22:37:27 发布

gavin_gxh

最新推荐文章于 2024-06-18 22:37:27 发布

阅读量479

点赞数

分类专栏： SAP ORACLE 文章标签：数据库

gavin-gxh

本文链接：https://blog.csdn.net/xiaofei2008gxh/article/details/127762784

版权

SAP 同时被 2 个专栏收录

120 篇文章 14 订阅

订阅专栏

ORACLE

8 篇文章 0 订阅

订阅专栏

SAP ehp7 on oracle 12c ，我用dbeaver连接的oracle，直接查数据出来 eg.物料，客户，供应商，凭证号等带有前导0 ，实际外部系统不需要前导0 要处理一下。

select trim(LEADING '0' FROM caufv.aufnr) AS aufnr,trim(LEADING '0' from caufv.PLNBEZ) AS PLNBEZ,caufv.GAMNG,trim(LEADING '0' FROM resb.matnr) AS matnr,
makt.MAKTX ,resb.lgort,mara.labor,resb.BDMNG,T024X.LBTXT
from caufv
join resb on resb.rsnum = caufv.rsnum AND resb.MANDT  = caufv.MANDT 
join mara on mara.matnr = resb.matnr  AND mara.MANDT  = resb.MANDT 
JOIN makt ON makt.matnr = resb.matnr AND makt.SPRAS  = '1' AND makt.MANDT  = resb.MANDT 
join T024X on t024X.labor = mara.labor  AND T024X.SPRAS  = '1' AND t024x.MANDT = mara.MANDT 
where  mara.labor in ('006','007','008','009') AND resb.XLOEK <> 'X' AND caufv.aufnr = '000301961416' AND resb.XLOEK <> 'X'