Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as Plain Text by josh ( 13 years ago )
DECLARE
CURSOR dept_cur is SELECT deptno, dname, loc from dept;
CTR number;
BEGIN
FOR r_dept in dept_cur
LOOP
INSERT into old_dept VALUES r_dept;
ctr:= ctr + 1;
END LOOP;
DBMS_OUT.PUT_LINE(ctr || ' processed');
END;
Revise this Paste