oracle定义游标

declare

 cursor  mm is select * from user;

 mm_row mm%rowtype;

  guid  varchar2(100);

begin

for mm_row in mm loop

guid := mm_row.id

end loop;

commit;

end;