例1:
-----------------------------------------------------------------------------------------------------------------
declare
begin
for emp_record in(select * from emp)
loop
dbms_output.put_line('姓名:'||emp_record.ename||' 部门编号:'||emp_record.ename);
end loop;
end;
-------------------------------------------------------------------------------------------------------------------
例2:
------------------------------------------------------------------------------------------