Re: SQL*Plus spooling problem

In sql*plus type
show lines
if this is less than the total length of the columns you are selecting (not forgetting the 2 spaces between each column that ORACLE uses by default) then the output will be split over multiple lines.

add a line
set linesize xxx (where xxx = total record length required) before executing your query Received on Sat Feb 22 1997 - 00:00:00 CST