摘要：
create or replace procedure Proc_Update_StaffInfois temp number; cursor cur_staff is select * from HR_RS_Staff where Deleted = 0 and sysdate > EntryTime + 365;begin for u in cur_staff loop temp := mod(floor(sysdate - to_date(u.EntryTime,'yyyy-MM-dd')),365); if temp <> 0 then -- 员工企龄 阅读全文
