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 10.1.0.2 to 10.2.0.1 [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***

Goal

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.

Solution

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 hundreds of Community platforms