匿名过程
来源:互联网 发布:spark sql使用 编辑:程序博客网 时间:2024/05/21 10:02
--select * from ll_ps_temp12_from11
DECLARE
CURSOR c_ps12 IS
SELECT * FROM ll_ps_temp12_from11 pt12;
v_branch_name VARCHAR2(200);
v_department_id NUMBER;
p_oa_branch_id NUMBER;
p_oa_branch_name VARCHAR2(100);
p_retcode VARCHAR2(100);
p_errmsg VARCHAR2(100);
v_count NUMBER;
v_email VARCHAR2(100);
v_user_id111 NUMBER;
BEGIN
FOR v_ps12 IN c_ps12 LOOP
dbms_output.put_line('employee_number=' || v_ps12.employee_number);
IF v_ps12.employee_number IS NOT NULL THEN
SELECT COUNT(1)
INTO v_count
FROM mms_oa_user mou,
mms_oa_user_dept ud,
mms_oa_department d
WHERE (decode(sign(length(mou.user_workid) - 6),
-1,
'281' || lpad(mou.user_workid,
5,