使用for in loop,实质是隐式游标,对于依据检索结果集进行处理的情况非常方便
For r_sys In (Select staff_name From v_tr_member where team_sn=m_team_sn order by rowid) Loop if pass_summary is null then pass_summary:=r_sys.staff_name; Else pass_summary:=pass_summary||','||r_sys.staff_name; End If; End Loop;