CREATE OR REPLACE
PROCEDURE PRINTROW AS
--声明行变量及游标
myrow EMP%rowtype;
cursor mycur is select * from EMP;
BEGIN
--打开游标
OPEN mycur;
--循环进行操作
LOOP
FETCH mycur INTO myrow;
EXIT WHEN mycur%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('部门号是:'||myrow.empno||' 部门名称:'||myrow.ename);
--INSERT INTO EMP (...) VALUES (....);
--COMMIT;
END LOOP;
--关闭游标
close mycur ;
END PRINTROW;
PROCEDURE PRINTROW AS
--声明行变量及游标
myrow EMP%rowtype;
cursor mycur is select * from EMP;
BEGIN
--打开游标
OPEN mycur;
--循环进行操作
LOOP
FETCH mycur INTO myrow;
EXIT WHEN mycur%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('部门号是:'||myrow.empno||' 部门名称:'||myrow.ename);
--INSERT INTO EMP (...) VALUES (....);
--COMMIT;
END LOOP;
--关闭游标
close mycur ;
END PRINTROW;