FREE SOFTWARE: Data exchanger between Oracle and text files.
From: Batayan <kawabata_at_personal.email.ne.jp>
Date: Wed, 07 Apr 1999 22:46:42 +0900
Message-ID: <370B61C2.6FD7DCE1_at_personal.email.ne.jp>
I have updated chcsv 2.0, available from my web site.
Date: Wed, 07 Apr 1999 22:46:42 +0900
Message-ID: <370B61C2.6FD7DCE1_at_personal.email.ne.jp>
I have updated chcsv 2.0, available from my web site.
The main feature of chcsv 2.0 is better performance by "Array fetch" than before.
[What are chcsv/csvload?]
chcsv and csvload are simple and convenient Oracle tools
to exchange data between Oracle table and text-files (CSV format).
o chcsv is to read SQL sentence from standard input
( or a file indicated by -i option ) and write results into standard output ( or a file indicated by -o option ). It is flexible to change the terminator and enclosure of columns.
o csvload is to read a CSV file and load it into Oracle table.
If the table already has the record ( that means this table has UNIQUE constraint ), csvload loads this record as "UPDATE", otherwise as "INSERT". You don't need to create a parameter file because csvload load just as the default sequence of columns of the table.
The sources are released under the terms of the GNU GPL.
home page: http://www.asahi-net.or.jp/~nq7t-kwbt/oracle/index.html
-- Batayan kawabata_at_personal.email.ne.jpReceived on Wed Apr 07 1999 - 15:46:42 CEST