Re: spooling a csv file from a table (problems)

On Sat, 9 Jun 2001 13:33:47, "Nicholas Mudie" <nmudie_at_chello.com> wrote:

> Hello,
>
> I;m trying to spool the contents of a table to .csv format but when I do:
>
> SQLPLUS> set heading off
> SQLPLUS> set feedback off
> SQLPLUS> spool factors.csv
> SQLPLUS> select tstamp|| ',' ||pkg|| ','||prod from cfga.factors;
>
> spool off
>
> This runs fine and adds the records to the file but what happens is that the
> ..csv file has this at the top
>
> SQLPLUS> select tstamp|| ',' ||pkg|| ','||prod from cfga.factors;
>
> ok, so I could VI to my file and take this out but I have huge files which
> vi can't cope with. There must be a spool command that ONLY writes the
> records to the file and not everything that you type.
>
> so, my question is...WHAT is the command which stops the sql statement being
> written to the file?
>
> Regards,
> Nicholas
> Chello
>

Chello, take a look at some of the software products that create CSV and TAB files from Oracle tables.

We have one at http://www.kiyoinc.com/nxtract.html but there are others.

--
cory