SET SERVEROUTPUT ON
DECLARE
num VARCHAR2(50);
sal NUMBER;
i NUMBER;
nr_sal NUMBER;
maxim NUMBER;
minim NUMBER;
BEGIN
SELECT COUNT(id_angajat),MAX(id_angajat),MIN(id_angajat) INTO nr_sal,maxim,minim
FROM angajati;
FOR i IN minim..maxim
LOOP
SELECT nume,salariul INTO num,sal
FROM angajati
WHERE id_angajat = i;
DBMS_OUTPUT.PUT_LINE('Salariatul cu numele '||num||' are salariul: '||sal);
EXIT WHEN i>maxim;
END LOOP;
END;