对sql脚本的语句是在不熟悉,这次为了写这些东西 花了好长时间找资料写出来的,还记得以前我sqlserver脚本写的多溜啊,工作后就没在写过了,都忘记了
记录一下吧 下次还要用 直接用这段修修补补就可以套着
DECLARE
v NUMBER := 0;
partner_v VARCHAR2(50) := '';
subpartner_v VARCHAR2(50) := '';
BEGIN
FOR item IN (SELECT *
FROM YCPAY.TAB_EMP_PARTNER t
WHERE t.EMP_CODE IN (SELECT t.emp_code
FROM ycpay.tab_emp_partner t
GROUP BY t.emp_code
HAVING count(1) < 3))
LOOP
SELECT count(1)
INTO v
FROM YCPAY.TAB_EMP_PARTNER T
WHERE T.EMP_CODE = item.EMP_CODE AND T.PAYMENT_PLATFORM = 1;
dbms_output.put_line('登录成功'||v);--输出语句
IF v = 0
THEN
FOR item2 IN (SELECT *
FROM ycpay.t_base_site t3
WHERE t3.site_code = (SELECT t2.owner_site
FROM ycpay.t_base_employee T2
WHERE t2.employee_code = item.EMP_CODE))
LOOP
dbms_output.put_line('登录成功2:'||item2.site_type);--输出语句
IF item2.site_type = 2
THEN
SELECT
T4.PARTNER,
T4.SUBPARTNER
INTO partner_v, subpartner_v
FROM ycpay.TAB_PARTNER_BANK T4
WHERE T4.COMPANY_CODE = item2.site_code;
INSERT INTO ycpay.TAB_EMP_PARTNER VALUES
(SEQ_EMP_PARTNER.nextval, item.EMP_CODE, partner_v, subpartner_v, item.EMP_NAME, sysdate, 2, 1, '手动数据库导入',
sysdate, '69840', '69840');
else
SELECT
T4.PARTNER,
T4.SUBPARTNER
INTO partner_v, subpartner_v
FROM ycpay.TAB_PARTNER_BANK T4
WHERE T4.COMPANY_CODE = item2.UP_SETTLE_CENTER;
INSERT INTO ycpay.TAB_EMP_PARTNER VALUES
(SEQ_EMP_PARTNER.nextval, item.EMP_CODE, partner_v, subpartner_v, item.EMP_NAME, sysdate, 2, 1, '手动数据库导入',
sysdate, '69840', '69840');
END IF;
END LOOP;
END IF;
END LOOP;
END;