HY2080单号编号为空怎么办

【2025-06-25】 HY2080没有单据编号的时候，重复执行

UPDATE CGDD1_TB SET DJBH =(
SELECT 'CG'||'20250624-'||LPAD(NVL(MAX(REVERSE(SUBSTR(REVERSE(djbh),1,3)))+1,1),3,'0')
FROM CGDD1_TB
Where substr(DJBH,1,2) = 'CG'
and to_char(dhrq,'yyyymmdd')='20250624') WHERE
ID = (SELECT MIN(ID) FROM CGDD1_TB WHERE
to_char(dhrq,'yyyymmdd')='20250624'
AND DJBH IS NULL);
COMMIT;