Home » RDBMS Server » Server Utilities » Re: How does one export an Oracle table to a Comma Delimited Flat File
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.
Previous Topic: Re: Sql-Loader Date Format
Next Topic: Re: Varchar2 over 255 bytes using SQL*Loader
Goto Forum:
  


Current Time: Sun Dec 22 22:18:42 CST 2024