Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- CURSOR NEWDEPT2_CURSOR IS SELECT DEPARTMENTID, DEPARTMENTNAME FROM NEWDEPT2;
- v_deptid NEWDEPT2.DEPARTMENTID%TYPE;
- v_deptname NEWDEPT2.DEPARTMENTNAME%TYPE;
- BEGIN
- OPEN NEWDEPT2_CURSOR;
- LOOP
- FETCH NEWDEPT2_CURSOR INTO v_deptid, v_deptname;
- EXIT WHEN NEWDEPT2_CURSOR%ROWCOUNT > 10;
- DBMS_OUTPUT.PUT_LINE(v_deptid || ' ' || v_deptname);
- END LOOP;
- CLOSE NEWDEPT2_CURSOR;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement