SQLDump: execute SQL queries and export results to a CSV file

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