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

Last updated on NOVEMBER 06, 2023

Applies to:

Goal

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.

Solution

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