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...
set
command... – gavenkoa Jun 25 '13 at 8:22