方法一:
declare
v_job varchar2(20);
v_empno number;
begin
for tb in (select * from emp )loop
v_job:=tb.job;
v_empno=tb.empno;
dbms_output.put_line(v_job);
dbms_output.put_line(v_empno);
end loop;
end
方法二:
declare
v_job varchar2(20);
v_empno number;
begin
select empno,job into v_empno,v_job from emp;
dbms_output.put_line(v_empno||' '||v_job);
end