Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- CURSOR c IS SELECT * FROM movie ORDER BY price DESC;
- mPointer c%ROWTYPE;
- BEGIN
- OPEN c;
- FETCH c INTO mPointer;
- FOR i IN 1..5 LOOP
- DBMS_OUTPUT.put_line(mPointer.title||': '|| mPointer.price);
- FETCH c INTO mPointer;
- END LOOP;
- CLOSE c;
- END;
- /
Add Comment
Please, Sign In to add comment