Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SERVEROUTPUT ON
- DECLARE
- v_top NUMBER(5) := 5;
- v_sal employees.salary%TYPE;
- CURSOR empSal_cur IS
- SELECT salary
- FROM employees
- ORDER BY salary DESC;
- v_count NUMBER(5):= 0;
- BEGIN
- DBMS_OUTPUT.PUT_LINE('SALARY');
- DBMS_OUTPUT.PUT_LINE('------');
- OPEN empSal_cur;
- LOOP
- FETCH empSal_cur
- INTO v_sal;
- DBMS_OUTPUT.PUT_LINE(v_sal);
- INSERT INTO top_salaries VALUES(v_sal);
- v_count := v_count +1;
- EXIT WHEN v_count = v_top;
- END LOOP;
- END;
- /
- SET SERVEROUTPUT ON
Add Comment
Please, Sign In to add comment