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

Name

SET TRUNCATE — Obsolete

Synopsis

The obselete TRUNCATE setting gives you the same choice as SET WRAP. You can choose whether to truncate lines longer than the LINESIZE setting.

Syntax

SET TRU[NCATE] {OFF | ON}

Parameters

SET TRU[NCATE]

Is the command, which may be abbreviated SET TRU.

OFF

Is the default setting, and allows long lines to be wrapped.

ON

Causes long lines of output to be truncated to match the current LINESIZE setting.

Examples

TRUNCATE and WRAP affect the same internal setting. Turning one on results in the other being turned off, and vice versa:

SQL> SHOW WRAP
wrap : lines will be wrapped
SQL> SET TRUNCATE ON
SQL> SHOW WRAP
wrap : lines will be truncated

Tip

Although you can issue the SHOW WRAP command to see the current value of the WRAP setting, you can't issue SHOW TRUNCATE. The SHOW command doesn't recognize TRUNCATE as a valid SQL*Plus setting.

When you select data longer than the LINESIZE and the WRAP setting is off, some versions of SQL*Plus display a warning message telling you that your rows may be truncated.