Re: exporting a table to a flat file in .csv format

Jon wrote:

> I am trying to dump data from a table to a flat file in .csv format. I have
> read documentation for sqlplus utility but I have not seen any information
> about this apart from defining specific format for columns. Do you know if
> this is posible from sqplus?
>
> Thanks

Simple ...

SELECT field1 || ',' || field2 || ',' || field3 FROM table;

Use TO_CHAR to handle any numbers or dates that need to be converted to strings for concatenation.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)