Oracle PLSQL Demo - 09.Open、Fetch遍历游标[Open, Fetch, Close Record CURSOR]

declare
    r_emp scott.emp%rowtype;
    cursor cur_emp is
        select t.* from scott.emp t;

begin

    open cur_emp;

    loop
        fetch cur_emp
            into r_emp;
    
        exit when cur_emp%notfound;
    
        dbms_output.put_line(r_emp.empno || '   ' || r_emp.sal);
    
    end loop;

    close cur_emp;

end;

 

转载于:https://www.cnblogs.com/nick-huang/p/4609072.html