WRAP
WRA[P] ON | OFF

Controls how SQL*Plus displays data output if it is too long for the current line width.

Keywords

ON

Specifies that the row's display should be continued (wrapped) on one or more subsequent lines. This option is the default.

OFF

Specifies that if a row is longer than the current line width, the display of the row should be truncated.

Get Oracle SQL: the Essential Reference 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.