Cursor to reference whole table : Introduction « Cursor « Oracle PL/SQL Tutorial






SQL>
SQL> create table big_table as select * from all_objects;

Table created.

SQL>
SQL> alter session set sql_trace=true;

Session altered.

SQL>
SQL> declare
  2      cursor c is select * from big_table;
  3      l_rec  big_table%rowtype;
  4  begin
  5      open c;
  6      fetch c into l_rec;
  7      close c;
  8  end;
  9  /

PL/SQL procedure successfully completed.

SQL>
SQL> drop table big_table;

Table dropped.

SQL>








25.1.Introduction
25.1.1.Cursors
25.1.2.First Cursor Example
25.1.3.An example of opening the cursorValue cursor
25.1.4.OPEN Cursor for fetching
25.1.5.A Cursor for counting
25.1.6.To prepare the comma-separated list
25.1.7.Create a cursor for update
25.1.8.An example of cursor variable assignment
25.1.9.Assigning different queries to the same cursor variable
25.1.10.Cursor to reference whole table
25.1.11.select first row to a cursor
25.1.12.Nested cursor
25.1.13.Cursor performance