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…
Best Answer
I don't think you can. The only thing I know that sort of does that (but is slightly annoying IMO) is the
PAUSE
option which waits for you to press enter between pages. The annoying part is that it pauses before the first row... You can Ctrl C to interrupt when you've seen enough.