SQL Plus - LONGCHUNKSIZE

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.

Syntax

set LONGC[HUNKSIZE] {80 | n}

Powered by ComboStrap