SET SERVEROUTPUT ON;
DECLARE
CURSOR c1 IS SELECT id_departament, denumire_departament FROM departamente WHERE id_departament IN(SELECT id_departament FROM angajati);
CURSOR c2 (id departamente.id_departament%TYPE) IS SELECT nume, salariul FROM angajati WHERE id_departament=id;
v1 c1%ROWTYPE;
v2 c2%ROWTYPE;
BEGIN
OPEN c1;
LOOP
    FETCH c1 INTO v1;
    EXIT WHEN c1%notfound;
    DBMS_OUTPUT.PUT_LINE(v1.denumire_departament);
    OPEN c2(v1.id_departament);
    LOOP
        FETCH c2 INTO v2;
        EXIT WHEN c2%notfound;
        DBMS_OUTPUT.PUT_LINE(v2.nume||' '||v2.salariul);
    END LOOP;
    CLOSE c2;
END LOOP;
CLOSE c1;
END;
/