Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*PLUS REPORT
Hi,
I have table test(a,b,c)
I have a scrip like this:
SET TERMOUT OF
SET PAGESIZE 0
SET HEADING OFF
SET FEEDBACK OFF
SPOOL TEST1.CSV
SELECT a || ´,´ || b || ´,´ || c FROM test;
SPOOL OFF
The TEST1.CSV look like this:
1,2,3 2,3,4 3,4,3 2,3,4
How do i avoid this last line("input truncate to 9 characters")?
Thanks
MIGUEL
Received on Thu Dec 11 1997 - 00:00:00 CST