摘要： 1、在select into 中使用BULK COLLECT，批量绑定到集合变量中 1 DECLARE 2 TYPE list_of_emp_type IS TABLE OF emp%ROWTYPE INDEX BY PLS_INTEGER; 3 list_emp list_of_emp_type; 4 BEGIN 5 SELECT * BULK COLLECT INTO list_emp FROM emp WHERE deptno = &deptno; 6 FOR i IN 1 .. list_emp.count LOOP 7 dbms_output.put_line... 阅读全文

摘要： 1、oracle9i之前只支持单行处理，如果采用forall批量绑定相比for循环速度快,这里在本机上测试insert100万行数据，批量绑定时间仅是循环DML的1/10。 1 DECLARE 2 TYPE list_of_name IS TABLE OF VARCHAR2(20) INDEX BY BINARY_INTEGER; 3 TYPE list_of_sal IS TABLE OF NUMBER(20) INDEX BY BINARY_INTEGER; 4 vname list_of_name; 5 sal list_of_sal; 6 BEGIN 7 FOR... 阅读全文