declare cursor myCursor is select * from 表名; myRow myCursor%rowtype; begin open myCursor; loop fetch myCursor into myRow; exit when myCursor%notfound; --要执行的SQL语句 end loop; end;