Advertisement
Guest User

Untitled

a guest
Jun 7th, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.40 KB | None | 0 0
  1. SET SERVEROUTPUT ON
  2. DECLARE
  3. CURSOR pensje IS SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES ORDER BY SALARY DESC;
  4. v_imie VARCHAR2(20);
  5. v_nazwisko VARCHAR2(25);
  6. v_pensja NUMBER(8,2);
  7. BEGIN
  8. OPEN pensje;
  9. LOOP
  10. FETCH pensje INTO v_imie, v_nazwisko, v_pensja;
  11. EXIT WHEN pensje%ROWCOUNT > 3;
  12. DBMS_OUTPUT.put_line(v_imie || ' ' ||  v_nazwisko || ' ' || TO_CHAR(v_pensja));
  13. END LOOP;
  14. CLOSE pensje;
  15. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement