About

LONGCHUNKSIZE is a system variable that:

• determines the default column width of a LONG, CLOB, NCLOB or XMLType defaults along with the system variable LONG and lines (linesize).
• Sets the size (in bytes) of the increments in which SQL*Plus retrieves a LONG, CLOB, NCLOB or XMLType value.

Articles Related

Syntax

set LONGC[HUNKSIZE] {80 | n}