Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. DECLARE
  2. Cursor C is select * from Employee ORDER BY salary DESC;
  3. Edet C%ROWTYPE;
  4.  
  5. BEGIN
  6. Open C;
  7. Loop
  8. fetch C into Edet;
  9. EXIT WHEN C%ROWCOUNT == 5;
  10. DBMS_OUTPUT.PUT_LINE(Edet);
  11. end loop;
  12. Close c;
  13. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement