数据库的小数位很长的情况，批量更新小数位信息
--超过4位小数的保留4位小数
UPDATE GBSC00.TCOSC02_ADS
SET PROD_YIELD_INDEX_VALUE_DAY = ROUND(PROD_YIELD_INDEX_VALUE_DAY, 4)
WHERE REGEXP_LIKE(PROD_YIELD_INDEX_VALUE_DAY, '\.\d{4,}')
AND REC_CREATOR_NAME = 'WA_TCOSC02' || dateYMD;
--.0000类型的舍掉小数
UPDATE GBSC00.TCOSC02_ADS
SET PROD_YIELD_INDEX_VALUE_DAY = REGEXP_REPLACE(REGEXP_REPLACE(
PROD_YIELD_INDEX_VALUE_DAY, '(\d+)(\.\d+?)0{1,}$', '$1$2'), '\.0{1,}$', '')
WHERE REGEXP_LIKE(PROD_YIELD_INDEX_VALUE_DAY, '\.\d+')
AND REC_CREATOR_NAME = 'WA_TCOSC02' || dateYMD;