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;