摘要：create or replace procedure ttttt is rs SYS_REFCURSOR; isRepart number; tempUserId number; V_username varchar2(1000); i number;begin i := 0; isRepart := 0; open rs for select s.userid from xtgl_superusers s where s.username like '%del%' and s.islock = 0; loop fetch rs into tempUserId; exit w 阅读全文