A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

How to make sqlplus output appear in one line

The following sqlplus commands maybe usefull:

  • SET LINESIZE linesize the length of the line. In most cases the maximum value for linesizeis 32767. You can find out your maximum value if you set LINESIZE to an invalid value and check the error message so SET LINESIZE 0 may give SP2-0267: linesize option 0 out of range (1 through 32767) (1)
  • SET TRIMSPOOL ON otherwise every line in the spoolfile is filled up with blanks until the linesize is reached.
  • SET TRIMOUT ON otherwise every line in the output is filled up with blanks until the linesize is reached.
  • SET WRAP OFF Truncates the line if its is longer then LINESIZE. This should not happen if linesize is large enough.
  • SET TERMOUT OFF suppresses the printing of the results to the output. The lines are still written to the spool file. This may accelerate the exectution time of a statement a lot.
  • SET PAGESIZE 0 to set an infinite pagesize and avoid headings , titles and so on There are some other SETparamters concering output (NUMWIDTH, NUMFORMAT, LONG, COLSEP) and performance (ARRAYSIZE,LONGCHUNKSIZE)


SET LONG 500;;

Comments are closed.