Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How does one export an Oracle table to a Comma Delimited Flat File
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
![]() |
![]() |