Oracle Tools
Let me introduce simple convert tools between
Oracle and CSV (plain-text). Because they are designed based on standar-input/output,they
are very useful if you are familiar with UNIX(TM) standard commands.
-
They are distributed under the GNU General Public License.
-
They come with ABSOLUTELY NO WARRANTY.
-
They are free software, and you are welcome to redistribute it under certain
conditions, GPL.
-
Currently they are woking on Solaris(TM), Linux(TM), Dec-Alpha(TM), HP-UX(TM)
platforms.
New Release!:
1999/5/21: chcsv and csvload executable on HP-UX
are ready to download.
1999/4/4: chcsv version
2.0. Array Fetch would give you better performance!.
Oracle Tips
- How
helpful are chcsv and csvload?
[What is chcsv?]
chcsv is a text convert tool from Oracle to CSV file . It reads SQL
sentence from standard-input (or a file indicated by "-i" option) and writes
result into standard-output (or a file indicated by "-o" option. It would
make it easy for you to do data conversion.
[What is csvload?]
The intelligent(?) CSV file loader csvload reads a CSV-file (or standard
input) and load it into an oracle table. Before loading, csvload gets information
about UNIQUE constraint of the table.If the record is already in the table,
csvload does UPDATE, otherwise does INSERT. You don't have to create parameter
files because csvload loads data just as the sequence of columns.
If you have comments or suggestions, email me at
kawabata@personal.email.ne.jp
chcsv
csvload