How To Set Linesize (Or Pagesize) Within SQL*Plus on Windows
Last updated on AUGUST 10, 2017
Applies to:SQL*Plus - Version 220.127.116.11 to 18.104.22.168 [Release 8.0.6 to 11.2]
"Checked for relevance on 01-May-2011"
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:
2. From menu, select Options-> Environment.
3. Scroll down to Set Options = linesize and note the Value (Current).
Then, exit from SQL*Plus.
~~ OR ~~
SQL> show linesize
SQL> show pagesize
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