My Oracle Support Banner

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

Last updated on NOVEMBER 06, 2023

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.


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

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

In this Document

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