DECLARE
merchantId TF_F_MERCHANT.MERCHANT_ID%type;
i integer;
BEGIN
i := 0;
DECLARE
CURSOR My_Cursor IS
SELECT T.MERCHANT_ID
FROM TF_F_MERCHANT T
WHERE T.MERCHANT_STATE = '1'
AND T.MERCHANT_TYPE = '0'
AND T.MERCHANT_ATTRIBUTION = '0';
BEGIN
OPEN My_Cursor;
LOOP
FETCH My_Cursor
INTO merchantId;
exit when My_Cursor%notfound;
INSERT INTO TC_F_ADS_CONFIG(ADS_CONFIG_ID,ADS_TYPE,PUSH__MERCHANT_TYPE,MERCHANT_ID,STAFF_ID,UPDATE_TIME) VALUES(concat(to_char(sysdate,'YYYYMMDDHH24MISS'),substr(merchantId,1,2)),'1','0',merchantId,'9800000',sysdate);
INSERT INTO TC_F_ADS_CONFIG_IMGLINK(ADS_CONFIG_ID,ADS_IMG_ADDR,ADS_IMG_URL,ADS_IMG_SORT,MERCHANT_ID) VALUES(concat(to_char(sysdate,'YYYYMMDDHH24MISS'),substr(merchantId,1,2)),'','',1,merchantId);
INSERT INTO TC_F_ADS_CONFIG_IMGLINK(ADS_CONFIG_ID,ADS_IMG_ADDR,ADS_IMG_URL,ADS_IMG_SORT,MERCHANT_ID) VALUES(concat(to_char(sysdate,'YYYYMMDDHH24MISS'),substr(merchantId,1,2)),'','',2,merchantId);
i := i + 1;
END LOOP;
commit;
CLOSE My_Cursor;
dbms_output.put_line('统计插入个数:' || i);
END;
END;