Oracle PLSQL示范1

Oracle PLSQL示例1

-- Created on 2010/04/16 by NANdeclare  -- 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;