I stop using SQL Developer as found more convenient to use SQL Plus inside Emacs SQLi mode.
SQL Developer on selects with large amount of rows show only few rows. But SQL Plus tend to dump all rows that match conditions. I can put
ROWNUM <= N but I often forget to do this.
Is there any option for SQL Plus to limit it output from
select statement? I will put it to
/opt/instantclient/glogin.sql in order to apply to each sesstion...