Skip to main content
Join the official 2019 Python Developers SurveyStart the survey!

No project description provided

Project description

sql-extract

Exports the results of Oracle sql code contained in a .sql file out to a csv file.

Usage

# run 
sql-extract in_sql_file.sql -o output_file.csv

# additional help
sql-extract -h

Parameters

Name Description Type Required
filename input .sql file name string yes
-o, --outfile output .csv file name string no
-d, --delimiter csv delimiter string no
-c, --quotechar csv quote character string no
-l, --login Oracle login string string no
-p, --password Oracle password string no
bind_vars any bind variables in the .sql file list no

Configuration

Store your Oracle login and password in full_login and db_password environment variables, respectively. Otherwise, you must use --login and --password to pass in your credential(s). You can alternatively store your login as an environment variable but not your password (or vice versa).

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for sql-extract, version 0.1.4
Filename, size File type Python version Upload date Hashes
Filename, size sql_extract-0.1.4-py3-none-any.whl (4.9 kB) File type Wheel Python version py3 Upload date Hashes View hashes
Filename, size sql_extract-0.1.4.tar.gz (3.7 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page