orcale数据库中,从一张表查询个别字段,并循环插入到另外一张表,入库字段不仅仅是原始表中的字段:
declare
cursor userids is
select id_
from pl_user;
begin
for item in userids loop
insert into pl_user_role (id_,role_id,user_id,create_by)
values (sys_guid(),'R_1002',item.id_,'1');
end loop;
end;