Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --4
- DECLARE
- num VARCHAR2(50);
- sal NUMBER;
- i NUMBER;
- nr_sal NUMBER;
- maxim NUMBER;
- minim NUMBER;
- nr NUMBER;
- BEGIN
- SELECT COUNT(id_angajat),MAX(id_angajat),MIN(id_angajat) INTO nr_sal,maxim,minim
- FROM angajati;
- i := minim;
- WHILE i <= maxim LOOP
- SELECT COUNT(id_angajat) INTO nr
- FROM angajati
- WHERE id_angajat = i;
- SELECT nume,salariul INTO num,sal
- FROM angajati
- WHERE id_angajat = i AND nr = 1;
- DBMS_OUTPUT.PUT_LINE('Salariatul cu numele '||num||' are salariul: '||sal);
- i := i+1;
- EXIT WHEN i>maxim;
- END LOOP;
- END;
- --5. Să se afiseze numele și salariul angajaților care au vechimea mai mare de 10 ani.
- 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 AND (SYSDATE - data_angajare)/365 > 10;
- DBMS_OUTPUT.PUT_LINE('Salariatul cu numele '||num||' are salariul: '||sal);
- EXIT WHEN i>maxim;
- END LOOP;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement