Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*Plus question. Trimming column lengths.

SQL*Plus question. Trimming column lengths.

From: Ray Teale <ray_at_BLAHholly.com.au>
Date: Tue, 12 Feb 2002 16:25:37 +1100
Message-ID: <jH1a8.17479$N31.876503@ozemail.com.au>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US