DECLARE TYPE c1 IS REF CURSOR; emp_cursor c1; v_ename scott.emp.ename%TYPE; v_sal scott.emp.sal%TYPE; -- cursor c1 is select ....BEGIN OPEN emp_cursor FOR SELECT t.ename,t.sal FROM scott.emp t WHERE t.deptno=10; LOOP FETCH emp_cursor INTO v_ename,v_sal; EXIT WHEN emp_cursor%NOTFOUND...【阅读全文】