Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. DECLARE
  2. CURSOR NEWDEPT2_CURSOR IS SELECT DEPARTMENTID, DEPARTMENTNAME FROM NEWDEPT2;
  3. v_deptid NEWDEPT2.DEPARTMENTID%TYPE;
  4. v_deptname NEWDEPT2.DEPARTMENTNAME%TYPE;
  5. BEGIN
  6. OPEN NEWDEPT2_CURSOR;
  7. LOOP
  8. FETCH NEWDEPT2_CURSOR INTO v_deptid, v_deptname;
  9. EXIT WHEN NEWDEPT2_CURSOR%ROWCOUNT > 10;
  10. DBMS_OUTPUT.PUT_LINE(v_deptid || ' ' || v_deptname);
  11. END LOOP;
  12. CLOSE NEWDEPT2_CURSOR;
  13. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement