–显式游标
DECLARE
–1.声明游标
CURSOR cur_emp IS SELECT * FROM emp;
vemp emp%ROWTYPE;
BEGIN
–2.打开游标
OPEN cur_emp;
–循环提取游标行
LOOP
–3.提取游标行
FETCH cur_emp INTO vemp;
–判断是否提取到行
EXIT WHEN cur_emp%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(vemp.ename || ‘,‘ || vemp.sal ||‘ ‘ || vemp.hiredate);
END LOOP;
–4.关闭游标
CLOSE cur_emp;
END;
/