sql循环嵌套、游标使用、循环结果集示例

sql循环嵌套、游标使用、循环结果集示例(oracle)：

declare

cursor user_id is select u.agent_user_id as userid

  from (select t.agent_user_id from agent_power t group by t.agent_user_id) temp,

       agent_user u

 where temp.agent_user_id = u.agent_user_id

   and u.agent_user_code like '%admin';

begin

for usersid in user_id loop

    declare i number;

    begin

    i:=60;

    while i <= 63 loop

          insert into agent_power p values(s_agent_power_id.nextval,usersid.userid,i,1,sysdate); 

          i:=i+1;

    end loop;

    end;

end loop;

end;