Oracle PLSQL示例1

-- Created on 2010/04/16 by NAN
declare
  -- Local variables here
  c_tobe com.cRef;
  TYPE t_table IS TABLE OF kbis.k002% TYPE;
  v_t_table t_table;
begin
  -- Test statements here
  SELECT t.k002 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));
  END LOOP;
     
  EXCEPTION
  WHEN OTHERS THEN
       dbms_output.put_line( Sqlerrm);
end;