Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How does one export an Oracle table to a Comma Delimited Flat File

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

From: <budgielover_at_yahoo.com>
Date: Thu, 09 Dec 1999 20:42:16 GMT
Message-ID: <82p476$icl$1@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 Thu Dec 09 1999 - 14:42:16 CST

Original text of this message

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