Data Converter between tables and text files(B

From: Batayan(B <kawabata_at_personal.email.ne.jp>
Date: Tue, 09 Mar 1999 23:10:47 +0900
Message-ID: <36E52BE7.8E5E88C4_at_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 Tue Mar 09 1999 - 15:10:47 CET