Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus question. Trimming column lengths.
try:
set trimspool on
set linesize 1000
set pagesize 999
check the documentation for more specifics, or for the complete listing of the commands and their uses.
Ray Teale wrote:
>
> Hi
>
> SQL*Plus 8.1.7
>
> I'm creating a comma delimited report :
>
> set linesize 100
> set pages 0
>
> select value1||','||value2||','||value3
> from example_table
> /
>
> ... does anybody know how I can prevent SQL*Plus from padding my records
> with spaces and always having the carriage return at position 100.
> I'd like the records to be variable length if poss.
>
> Thanks
>
> Ray Teale
Received on Tue Feb 12 2002 - 10:20:33 CST