Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- CURSOR CEgzaminy IS SELECT DISTINCT DATA_EGZ
- FROM EGZAMINY
- ORDER BY DATA_EGZ DESC;
- vData CEgzaminy%ROWTYPE;
- BEGIN
- OPEN CEgzaminy;
- IF CEgzaminy%ISOPEN
- THEN
- FETCH CEgzaminy INTO vData;
- WHILE CEgzaminy%FOUND AND CEgzaminy%ROWCOUNT <= 3 LOOP
- DBMS_OUTPUT.PUT_LINE(vData.DATA_EGZ);
- FETCH CEgzaminy INTO vData;
- END LOOP;
- CLOSE CEgzaminy;
- END IF;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement