看一下下面的例子就会明白了(显示所有雇员的名字)。DECLARE TYPE emp_cursor_type IS REF CURSOR; c1 EMP_CURSOR_TYPE; v_emp_record emp%ROWTYPE;BEGIN OPEN c1 FOR SELECT * FROM emp; LOOP
FETCH c1 INTO v_emp_record;
EXIT WHEN c1%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(v_emp_record.ename); END LOOP; CLOSE c1;END;...
专家都被你绕进去了 呵呵type v_cursor is ref cursor;open v_cursor forselect COLUMN_NAME,DATA_TYPE,DATA_LENGTH from USER_TAB_COLUMNS where table_name='xx_table';你要是不知道表名,那就无解了1 ...