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.

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.jp
Received on Wed Apr 07 1999 - 15:46:42 CEST

Original text of this message