mas mas developer, ada cara lain yg lebih kenceng ga ya? kok dibanding for loop biasa malah sami mawon?
set serveroutput on set timing on declare l_out number; TYPE t_cursor IS TABLE OF xx1.acct%TYPE; l_cursor t_cursor; n number := 1; plsql_block varchar2(200); l_acct_num varchar2(60); begin plsql_block := 'BEGIN get...@dblink(:x1, :x2); END;'; select acct bulk collect into l_cursor from xx1 where rn between 0 and 1000; forall I in 1..l_cursor.COUNT execute immediate plsql_block using in l_cursor(I), out l_out; dbms_output.put_line(n||' '||l_out); n:=n+1; end; / [Non-text portions of this message have been removed]
