SQLDump: execute SQL queries and export results to a CSV file
Table of Content
SQLDump is a cross-platform command line utility to execute SQL queries and export results to a CSV file.
It currently supports Oracle and MySQL.
Usage
To use you need Java installed
java -jar SQLDump-0.4.jar -url [jdbc:oracle:thin:@hostname:port:sid] -user [username] -pass [password] -sql [query]Remember to enclose your SQL query with quotes!
Required
- -url A database url of the form jdbc:subprotocol:subname
- -user,--username The database user on whose behalf the connection is being made
- -pass,--password The user's password
- -sql,--query Any SQL statement
Optional
- -f,--file File path of the csv report
- -headers,--include-headers Include column headers in generated file
