Command line utility to execute SQL queries and export results to a CSV file.
Currently only supports Oracle and MySQL. For additional driver support please contact me or fork the project.
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!
- -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
- -f,--file File path of the csv report
- -headers,--include-headers Include column headers in generated file