angelina90的专栏

原创 在SELECT INTO中使用BULK COLLECT

结合一个实例来理解一下在SELECT INTO 语句中批量绑定的使用：SQL> conn lunar/lunar Connected. SQL> SET SERVEROUTPUT ON SQL> Create Or Replace Procedure lunartest2 Is   2     TYPE NumTab IS TABLE OF emp.empno%TYPE;   3     TYPE