Guest User

Untitled

a guest
Jun 11th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.52 KB | None | 0 0
  1. SET SERVEROUTPUT ON
  2. DECLARE
  3.   v_top NUMBER(5) := 5;
  4.   v_sal employees.salary%TYPE;
  5.   CURSOR empSal_cur IS
  6.     SELECT salary
  7.     FROM employees
  8.     ORDER BY salary DESC;
  9.    
  10.   v_count NUMBER(5):= 0;
  11. BEGIN
  12.   DBMS_OUTPUT.PUT_LINE('SALARY');
  13.   DBMS_OUTPUT.PUT_LINE('------');
  14.   OPEN empSal_cur;
  15.   LOOP
  16.     FETCH empSal_cur
  17.     INTO v_sal;
  18.     DBMS_OUTPUT.PUT_LINE(v_sal);
  19.     INSERT INTO top_salaries VALUES(v_sal);
  20.     v_count := v_count +1;
  21.     EXIT WHEN v_count = v_top;
  22.   END LOOP;
  23.  
  24. END;
  25. /
  26. SET SERVEROUTPUT ON
Add Comment
Please, Sign In to add comment