近期工作中遇到了一个问题,数据库中有一批数据需要处理,于是想到了这个。做个记录
--声明区
declare
employee_uuid varchar2(100);
employee_number varchar2(100);
employee_property NUMBER(1);
role_uuid varchar(100);
--方法体
begin
-- 查询查询所有人员批量新增角色
for item in (select e.employee_uuid,e.employee_number,e.employee_property from cas.cas_employee e ) loop
-- 将查询到的数据赋值给变量
employee_uuid := item.employee_uuid;
employee_number := item.employee_number;
employee_property := item.employee_property;
-- 判断人员所属体系(1:内部 2:代理商)
if employee_property = 1 then
role_uuid := 'SMSA_AGENT_ADMIN_MINIPOSX';
insert into agent.agent_employee_role_relation (EMPLOYEE_UUID, EMPLOYEE_NO, ROLE_UUID) values (employee_uuid,employee_number,role_uuid);
else
role_uuid := 'SMSA_AGENT_AGENT_MINIPOSX';
insert into agent.agent_employee_role_relation (EMPLOYEE_UUID, EMPLOYEE_NO, ROLE_UUID) values (employee_uuid,employee_number,role_uuid);
end if;
end loop;
end;