sqlcsv
Export query sql to csv format
Install
extract from jar
jar -xvf sqlcsv.jar sqlcsv.sh
Populate Argument
| parameter | meaning |
|---|---|
| -j jdbc-url | jdbc connection |
| -u username | username |
| -p password | password |
| -q query | sql query |
| -qf query.sql | file sql script |
| -d delimiter | delimiter |
| -quote | using quote |
| -o file | file output optional default std IO. |
Sample
java -jar sqlcsv.jar -j "jdbc:oracle:thin:@localhost:1521:xe" -u oracle -p oracle -q "select * form dual" -quote
Runtime
Minimum Running Requerement
- JDK 7
- Heap space 256 Mb