Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- Cursor C is select * from Employee ORDER BY salary DESC;
- Edet C%ROWTYPE;
- BEGIN
- Open C;
- Loop
- fetch C into Edet;
- EXIT WHEN C%ROWCOUNT == 5;
- DBMS_OUTPUT.PUT_LINE(Edet);
- end loop;
- Close c;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement