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 -> formating output

formating output

From: ed zappulla <zappullae_at_rcn.com>
Date: Wed, 20 Feb 2002 21:30:16 -0500
Message-ID: <a51lso$g53$1@bob.news.rcn.net>


anyone know how to eliminate the lining up of columns from sqlplus? 8.1.6. i want a csv output and i get a lot of xtra white space before and after the commas

set tab off;
set trim on;
set linesize 9999;
set colsep ',';
set newpage none;
set heading off;
set wrap off;
set feedback off;
set pagesize 0;

select * from tab; Received on Wed Feb 20 2002 - 20:30:16 CST

Original text of this message

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