My Oracle Support Banner

How to have a desired number of rows in iSQLPLUS (Doc ID 339010.1)

Last updated on OCTOBER 28, 2016

Applies to:

SQL*Plus - Version to [Release Oracle10g]
Information in this document applies to any platform.
Information in this document applies to any platform.
***Checked for relevance on 21-Jun-2013***


If you change the "Number of rows on each page"  from the preference of iSQLPLUS, the change holds good only for that session.  As soon as you logout and login again, the number of rows getting displayed again changes to the default.

This document shall tell how to effect the changes globally on the number of rows displayed per page as a result of the query.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.