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

Name

SET WRAP

Synopsis

The WRAP setting controls how SQL*Plus prints lines that contain more characters than the current LINESIZE setting allows. With WRAP ON, long lines are wrapped around and continued on as many physical lines as necessary. With WRAP OFF, lines are truncated to match the LINESIZE setting.

Syntax

SET WRA[P] {ON | OFF}

Parameters

SET WRA[P]

Is the command, which may be abbreviated SET WRA.

ON

Causes long lines to be wrapped around to two or more physical lines in order to print and still fit within the LINESIZE setting.

OFF

Causes long records to be truncated to the current LINESIZE setting.

Examples

The following example shows the results of issuing the same SELECT statement, once with WRAP turned on and once with it turned off:

SQL> SET WRAP ON
SQL> SELECT * FROM ALL_VIEWS WHERE VIEW_NAME = 'ALL_VIEWS';
OWNER                          VIEW_NAME                      TEXT_LENGTH
------------------------------ ------------------------------ -----------
TEXT
-----------------------------------------------------------------------------
TYPE_TEXT_LENGTH
----------------
TYPE_TEXT
-----------------------------------------------------------------------------
OID_TEXT_LENGTH
---------------
OID_TEXT
-----------------------------------------------------------------------------
VIEW_TYPE_OWNER                VIEW_TYPE
------------------------------ ------------------------------
SYS                            ALL_VIEWS                              821
select u.name, o.name, v.textlength, v.text, t.typetextlength, t.typetext,
SQL> SET WRAP OFF
SQL> / rows will be truncated rows will be truncated ...