Oracle PLSQL示例2-- Created on 2010/04/16 by NANdeclare-- Local variables herec_tobe com.cRefTYPE
Oracle PLSQL示例2
-- Created on 2010/04/16 by NANdeclare -- Local variables here c_tobe com.cRef; TYPE t_table IS TABLE OF kbis% ROWTYPE; v_t_table t_table;begin -- Test statements here SELECT t.* BULK COLLECT INTO v_t_table FROM kbis t; --取出所有数据 FOR i IN 1 .. v_t_table.COUNT LOOP dbms_output.put_line(v_t_table(i).k002); END LOOP; EXCEPTION WHEN OTHERS THEN dbms_output.put_line( Sqlerrm);end;