Re: Exporting Oracle table to a plain ASCII file

From: <nasser_at_apldbio.com>
Date: 28 Aug 1998 22:16:34 -0700
Message-ID: <6s82ri$mqt@drn.newsguy.com>

 >Alan (achristie_at_wei.org) wrote:

>>
>> I would like to know if an utility exists to dump the contents of an Oracle
>> table to a plain ASCII file.

I wrote such a tool the other day in JDBC. The program I wrote uses the thin driver for oracle. my program will dump all related rows in all tables for some item, but the idea is the same. The program first finds what the schema is for that table (using jdbc calls), then it will format the output , it makes select jdcb calls to get the data and dispay it.

took only 3-4 hours to write, but saves me lots of time when I want to quickly look at some data in nice text output format.

Nasser Received on Sat Aug 29 1998 - 00:16:34 CDT