Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> formating output
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