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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sql_extract-0.2.tar.gz
(4.1 kB
view hashes)
Built Distribution
Close
Hashes for sql_extract-0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4a3377aa6dd74c3017b9f66e95e4e11144fb0b1ad1ade2ae0b1047901746bc07 |
|
MD5 | e64bffd996a6b38d427a2eb44dcd9624 |
|
BLAKE2b-256 | 7f902733971d32b97e8115e0db02ed952ae0ac2e3da0f30eb332de96c9162c91 |