Use implicit or explicit cursor to insert 50000 rows to a table : Implicit Cursor « Cursor « Oracle PL/SQL Tutorial






SQL> create table myTable ( x primary key )
  2   organization index as select 1 from dual;

Table created.

SQL> create or replace procedure implicit is
  2   dummy number;
  3  begin
  4   for i in 1 .. 50000 loop
  5       select 1 into dummy from myTable;
  6   end loop;
  7  end;
  8  /

Procedure created.

SQL> create or replace procedure explicit is
  2   cursor explicit_cur is select 1 from myTable;
  3   dummy number;
  4  begin
  5   for i in 1 .. 50000 loop
  6       open explicit_cur;
  7       fetch explicit_cur into dummy;
  8       close explicit_cur;
  9   end loop;
 10  end;
 11  /

Procedure created.

SQL>
SQL> drop table myTable;

Table dropped.








25.8.Implicit Cursor
25.8.1.Taking a Shortcut with CURSOR FOR Loops
25.8.2.%ISOPEN, %FOUND, %NOTFOUND variables aren't useful at all in CURSOR FOR loops
25.8.3.Implicit Cursor Attributes: SQL%NOTFOUND
25.8.4.Implicit Cursor Attributes Example: SQL%ROWCOUNT
25.8.5.NO_DATA_FOUND Exception vs. %NOTFOUND
25.8.6.Looping through a Cursor by Using the LOOP Command
25.8.7.Adding an Exception Handler to a CURSOR FOR Loop
25.8.8.Knowing what record is processing
25.8.9.Use %ROWCOUNT to detect what record you are processing at a given point
25.8.10.Declare and use a cursor in for loop
25.8.11.Implicit cursor open, fetch and close
25.8.12.Handling exceptions in implicit cursors
25.8.13.Returning an implicit cursor into a record
25.8.14.The Difference between Explicit and Implicit Cursors
25.8.15.Implicit Cursor: Too many rows
25.8.16.Implicit Cursor: No rows found
25.8.17.Use implicit or explicit cursor to insert 50000 rows to a table
25.8.18.Test cursor attributes with an implicit cursor