SQL Plus - LONGCHUNKSIZE

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - 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.
Advertising

3 - Syntax

set LONGC[HUNKSIZE] {80 | n}
lang/sqlplus/longchunksize.txt · Last modified: 2017/05/09 16:51 by gerardnico