DECLARE
CURSOR emp_cur
IS
SELECT * FROM pub_employee
WHERE logout_flag = 0
AND jysj = to_date(to_char(sysdate,'YYYY-MM-DD'),'YYYY-MM-DD');
BEGIN
FOR emp_row IN emp_cur LOOP
-- 注销
UPDATE pub_employee SET logout_flag = 1, logout_date = sysdate, emp_nature = '025' WHERE emp_id = emp_row.emp_id;
END LOOP;
COMMIT;
END;
转载于:https://my.oschina.net/chenrh/blog/1535127