Witam
Mialem ostatnio zadanie na zajeciach na studiach zwiazane z kursorami. Z pomoca kolegi zrobilem je, jednak nie do konca rozumiem po co linijka
FETCH emp_cursor INTO v_lname,v_sal;
jest dwa razy. Caly kod wyglada tak:
delete from top_dogs;
DECLARE
v_num NUMBER(3) := 5;
v_lname employees.last_name%TYPE;
v_sal employees.salary%TYPE;
CURSOR emp_cursor IS
SELECT last_name, salary
FROM employees
ORDER BY salary DESC;
BEGIN
OPEN emp_cursor;
FETCH emp_cursor INTO v_lname,v_sal;
WHILE emp_cursor %ROWCOUNT <= v_num AND emp_cursor%FOUND LOOP
INSERT INTO top_dogs (name,salary) VALUES (v_lname,v_sal);
FETCH emp_cursor INTO v_lname,v_sal;
END LOOP;
CLOSE emp_cursor;
COMMIT;
END;