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 -> Re: SQL*PLUS REPORT

Re: SQL*PLUS REPORT

From: John P. Higgins <jh33378nospam_at_deere.com>
Date: 1997/12/11
Message-ID: <3490BE77.9E9@deere.com>#1/1

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

Original text of this message

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