How To Set Linesize (Or Pagesize) Within SQL*Plus on Windows

(Doc ID 130735.1)

Last updated on AUGUST 10, 2017

Applies to:

SQL*Plus - Version 8.0.6.0 to 11.2.0.4 [Release 8.0.6 to 11.2]
Generic Windows
"Checked for relevance on 01-May-2011"


Goal

The environment variable reflects the wrong linesize (or pagesize) when logging into SQL*Plus. How do I correct this on a Windows PC so that it will:

     (A) Reflect the correct linesize (or pagesize) at login?
     (B) Reflect the correct linesize (or pagesize) only for the current SQL*Plus session?

You have confirmed the current settings for pagesize/linesize by doing one of the following methods:

1. Logon to SQL*Plus.
2. From menu, select Options-> Environment.
3. Scroll down to Set Options = linesize and note the Value (Current).
Then, exit from SQL*Plus.


~~ OR ~~

Logon to SQL*Plus and execute SHOW commands:

SQL> show linesize
linesize 100

SQL> show pagesize
pagesize 24

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