Re: How does one export an Oracle table to a Comma Delimited Flat File

Depending on how automated you want this to be, I've found a couple of different ways.
1. You can use a decode statement
2. Use SQL Navigator from Quest Software. They have a very nice export to text file ability that can use any character as a separator. 3. If you are doing this in SQL*Plus, try setting the trim on, termout off, and spooling on

If you are going to do this manually every once in a while, I would definitely recommend SQL Navigator as it has so many capabilities. My job became so much easier when I found that program.

Hope that helps.

<budgielover_at_yahoo.com> wrote in message news:82p476$icl$1_at_nnrp1.deja.com...
> I need to export an oracle table to a csv file by using SQLPLUS
> I've tried using:
> SQL>set colsep ","
> but Oracle tabs all the columns automactically leaving unwanted spaces
> between fields
> I've also tried using:
> select col1||',',col2||',', ... from table_name;
> but it also has the spacing problem
>
> If you know how to solve this or if you know any fancy utility like bcp
> that will allow exporting table to delimited file.. that will be great!
>
> any help will be greatly appreciated!
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 10 1999 - 23:05:59 CST