|
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>
|