Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*Plus question. Trimming column lengths.
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 Mon Feb 11 2002 - 23:25:37 CST