当前位置: 代码迷 >> SQL >> Oracle PLSQL示范2
  详细解决方案

Oracle PLSQL示范2

热度:48   发布时间:2016-05-05 12:51:27.0
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;
  相关解决方案