Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*PLUS REPORT
miguel wrote:
>
> 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
Put an EXIT at this point in your script.
>
> The TEST1.CSV look like this:
> 1,2,3
> 2,3,4
> 3,4,3
> 2,3,4
> input truncate to 9 characters
>
> How do i avoid this last line("input truncate to 9 characters")?
> Thanks
> MIGUEL
Received on Thu Dec 11 1997 - 00:00:00 CST