Re: Help Required: How can I export my Oracle data into a flat file

[Quoted] The easier way is to use a 3rd party tool to export the data : I use Crystal Reports 8 from seagate and it exports in comma delimited format ( [Quoted] along with many, many others) which I can use in many other apps (or as a data file for SqlLoader to use)
[Quoted] many other report writers will allow exports to a dilimited format, as will Access, Excel etc...

"Abey Joseph" <abeyj_at_netzero.net> wrote:

>Antony,
> I am not an expert on this matter... I don't know if there is a
>better/more efficient way to accomplish the same.
>
>SPOOL filename
>SELECT * FROM table;
>
>The above statement would write all columns in all records to filename. The
>fields will be fixed length. If you want delimited fields you would have to
>write the SQL statement and concatenate the delimiter and columns. I hope
>there's an easier way...
>
>Abey Joseph.
>
>"PSINet News Service" <Antony.Amalraj_at_tpg.com> wrote in message
>news:7E8A4.416$iB5.781_at_client...
>> Hello All,
>>
>> I am new to oracle, I want to export the table data(From
>oracle)
>> alone into flat file.From the flat file I want to import the data into
>> another database(db2) table.
>>
>> Can any one help me.
>>
>> Regards
>> Antony
>>
>>
>>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Mar 16 2000 - 23:03:19 CET