Re: SQL*PLUS REPORT

John P. Higgins wrote:

> 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
 sqlplus generate this message when last line incomplete (without "LF" or "CR" characters).

--
Sergey V. Nikolayenko Software Engineer, Server Applications
Parametric Technology     email: tmpsnikolayenko_at_ptc.com
128 Technology Drive      phone: (617) 398-6519
Waltham, MA 02154           fax: (617) 398-5633