You have to use the COLUMNcommand to format individual columns.Į.g. There are some other SET parameters concerning output (NUMWIDTH, NUMFORMAT, LONG, COLSEP) and performance (ARRAYSIZE, LONGCHUNKSIZE).SET PAGESIZE 0 to set an infinite pagesize and avoid headings, titles and so on.This may accelerate the exectution time of a statement a lot. The lines are still written to the spool file. SET TERMOUT OFF suppresses the printing of the results to the output.This should not happen if linesize is large enough. SET WRAP OFF Truncates the line if its is longer then LINESIZE.SET TRIMOUT ON otherwise every line in the output is filled up with blanks until the linesize is reached.SET TRIMSPOOL ON otherwise every line in the spoolfile is filled up with blanks until the linesize is reached.So SET LINESIZE 0 may give SP2-0267: linesize option 0 out of range (1 through 32767) (1) You can find out your maximum value if you set LINESIZE to an invalid value and check the error message In most cases the maximum value for linesize is 32767. SET LINESIZE linesize the length of the line.The following sqlplus commands maybe usefull:
If you display LONG columns and their values contain line breaks then multiple lines will be printed for these column values and you cannot overrule this with sqlplus settings.
To see where the line breaks are actually placed in your output file. On Unix/Linux you can use head -1 output.txt to get the first line of a file and so check if this is as expected or you can use od -c output.txt|head If your viewer is less then -S the option you have to use according to It is also necessary to tell the viewer that you use to view the spool file not to wrap lines. It is not enough to force sqlplus not to wrap lines.