Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SERVEROUTPUT ON
- DECLARE
- CURSOR pensje IS SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES ORDER BY SALARY DESC;
- v_imie VARCHAR2(20);
- v_nazwisko VARCHAR2(25);
- v_pensja NUMBER(8,2);
- BEGIN
- OPEN pensje;
- LOOP
- FETCH pensje INTO v_imie, v_nazwisko, v_pensja;
- EXIT WHEN pensje%ROWCOUNT > 3;
- DBMS_OUTPUT.put_line(v_imie || ' ' || v_nazwisko || ' ' || TO_CHAR(v_pensja));
- END LOOP;
- CLOSE pensje;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement