SQL>
SQL> create table big_table as select * from all_objects;
Table created.
SQL>
SQL> declare
2 cursor c is select /*+ FIRST_ROWS(1) */ * from big_table order by owner;
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>