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 ...
Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.