FETCH 表1 INTO 表2;
EXIT WHEN 表1%NOTFOUND OR 表1%NOTFOUND IS NULL;
SELECT SUBSTR(LTRIM(TO_CHAR(SYSDATE,'YYYYMM')),4)||字段A||LTRIM(TO_CHAR(seqno,'0000000'))
INTO lo_A
FROM 表3
WHERE para='dd';
UPDATE 表3
SET seqno = seqno + 1
EXIT WHEN 表1%NOTFOUND OR 表1%NOTFOUND IS NULL;
SELECT SUBSTR(LTRIM(TO_CHAR(SYSDATE,'YYYYMM')),4)||字段A||LTRIM(TO_CHAR(seqno,'0000000'))
INTO lo_A
FROM 表3
WHERE para='dd';
UPDATE 表3
SET seqno = seqno + 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货