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

From: proinfo <loladan_at_comic.com>
Date: Fri, 10 Dec 1999 12:52:43 -0500
Message-ID: <82rejv$b6k$1@autumn.news.rcn.net>

You can import your tab delimited output to MS Excel - it will fit into different columns nicely - then save as text with comma separated fields in Excel.

Daniel

<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 - 11:52:43 CST