| Re: How does one export an Oracle table to a Comma Delimited Flat File [message #367975] |
Thu, 12 August 1999 09:28 |
Eric
Messages: 78
Registered: April 1999
|
Member |
|
|
|
I do not know how to accomplish this with SQL Plus, but Microsoft SQL Server 7.0 (client side) comes with an import/export data tool that is not very fast but can transfer from virtually any database server type to any other. This includes Oracle -> text file. You can choose the delimeter, whether or not the first row contains column headings etc... You could also write a very short program in Perl or C (easier in Perl) to read the data line by line through ODBC and send it to a text file however you want.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
