Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET serveroutput ON;
- DECLARE
- sal_max emp.sal%TYPE;
- avg_venit emp.sal%TYPE;
- CURSOR c_angajati IS SELECT ename, job, sal, comm, deptno FROM emp;
- angajati c_angajati%ROWTYPE;
- BEGIN
- FOR angajat IN c_angajati
- LOOP
- SELECT MAX(sal) INTO sal_max FROM emp
- WHERE deptno = angajat.deptno;
- SELECT AVG(sal + NVL(comm, 0)) INTO avg_venit FROM emp
- WHERE job = angajat.job;
- IF (angajat.sal = sal_max) THEN
- DBMS_OUTPUT.put_line('Salariu maxim ' || angajat.ename || ' '
- || angajat.sal || ' ' || angajat.deptno);
- ELSIF (angajat.sal > avg_venit * 1.15) THEN
- DBMS_OUTPUT.put_line('Venit mediu ' || angajat.ename || ' '
- || angajat.sal || ' ' || angajat.deptno);
- END IF;
- END LOOP;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement