Oracle的一个简单题目

etc

declare temp emp.字段1%type; tmp_字段1 emp.字段1%type; tmp_字段2 emp.字段2%type; tmp_字段3 emp.字段3%type; cursor cur_emp is select 字段1, 字段2, 字段3 from emp where 字段1 = temp; begin open cur_emp; loop fetch cur_emp into tmp_字段1, tmp_字段2, tmp_字段3; exit when cur_emp%notfound; end loop; end;