SQL Plus - LONGCHUNKSIZE

Card Puncher Data Processing

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}





Discover More
Card Puncher Data Processing
SQL Plus - Csv Export

How to export a CSV with SQL Plus. Export of the tables all_objects where:
Card Puncher Data Processing
SQL Plus - Formatting Reports

How to format SQLplus output (ie ) All below parameters can be configured in the login script. Through the SQLPlus COLUMN command with the heading options, you can change the column headings...
Card Puncher Data Processing
SQL Plus - Long

LONG is a system variable that: sets the maximum width (in bytes) for displaying LONG, CLOB, NCLOB and XMLType values; and for copying LONG values. determines the default column width of a LONG, CLOB,...
Card Puncher Data Processing
SQL Plus - System Variable (Configuration)

System Variables Description APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO package. arraysize Sets the number of rows, called a batch, that SQLPlus...



Share this page:
Follow us:
Task Runner