SQL Plus - Long

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

1 - About

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, NCLOB or XMLType defaults along with the system variable LONGCHUNKSIZE and lines (linesize).

3 - Syntax

set long {80|n}