SQL Plus - Linesize

Card Puncher Data Processing

About

Linesize is a system variable and define the default width at which sqlplus wraps out.

You can truncate the wrap parts thanks to the wrap system variable.

Syntax

set linesize 160





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 - LONGCHUNKSIZE

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...
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 - Wrap

Wrap is a feature of SQL Plus that can be set: globally with a system variable by column with the command Wrap is a system variable that turns on or off (default) globally the truncating of...
Card Puncher Data Processing
System Variable

s 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 will fetch...



Share this page:
Follow us:
Task Runner