How to Find the LINESIZE Maximum Value (It is System Dependent)

(Doc ID 1547262.1)

Last updated on MARCH 08, 2017

Applies to:

SQL*Plus - Version and later
Information in this document applies to any platform.


LINESIZE depends on the operating system. How to know the valid range in your platform?

The manual SQL*Plus® User's Guide and Reference  => "Set LINESIZE" reads:

SET LIN[ESIZE] {80 | n} SET LIN[ESIZE] {150 | n} in iSQL*Plus

Sets the total number of characters that SQL*Plus displays on one line before beginning a new line.

It also controls the position of centered and right-aligned text in TTITLE, BTITLE, REPHEADER and REPFOOTER. Changing the linesize setting can affect text wrapping in output from the DESCRIBE command. DESCRIBE output columns are typically allocated a proportion of the linesize. Decreasing or increasing the linesize may give unexpected text wrapping in your display. You can define LINESIZE as a value from 1 to a maximum that is system dependent.


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