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

1. Oracle PL/SQL Tutorial
2. Cursor
3. Introduction

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>