【PL/SQL】CURSOR

set pagesize 120
set serveroutput on

declare
c_id employees.employee_id%type;
c_ln employees.last_name%type;
c_s employees.salary%type;

cursor cc is
select employee_id, last_name, salary
from employees
where employee_id <125;

begin
open cc;
loop
fetch cc into c_id, c_ln, c_s;
exit when cc%notfound;

if c_s > 5000 then

DBMS_OUTPUT.PUT_LINE(c_id ||’ ’ || c_ln ||’ ’ || c_s);

end if;
end loop;
close cc;

end;
/