Cursor Ödevi

gistfile1.txt

DECLARE
   c_id hr.employees.employee_id%type;
   c_name hr.employees.first_name%type;
   c_surname hr.employees.last_name%type;
 
   CURSOR c_employees is
      SELECT employee_id, first_name, last_name FROM hr.employees;
BEGIN
   OPEN c_employees;
   LOOP
      FETCH c_employees into c_id, c_name, c_surname;
      **
      EXIT WHEN c_employees%notfound;
      dbms_output.put_line(c_id || ' ' || c_name || ' ' || c_surname);
   END LOOP;
   CLOSE c_employees;
END;
/