Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

SET LINESIZE

Synopsis

The LINESIZE setting controls the number of characters SQL*Plus prints on one physical line. The default setting is 80 (150 in iSQL*Plus). The maximum width is system-dependent, though it's often 32,767 characters.

Syntax

SET LIN[ESIZE] line_width

Parameters

SET LIN[ESIZE]

Is the command, which may be abbreviated SET LIN.

line_width

Is the new line width, expressed as a number of characters.

The LINESIZE setting is referenced by SQL*Plus when you define any headers or footers (see TTITLE, BTITLE, REPHEADER, REPFOOTER) that are centered or right-justified.