Simple Data converter between tables and text-files

From: Batayan <kawabata_at_personal.email.ne.jp>
Date: Thu, 11 Mar 1999 23:01:18 +0900
Message-ID: <36E7CCAE.78C9F114@personal.email.ne.jp>

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 Thu Mar 11 1999 - 08:01:18 CST