Python-oracledb Examples

This directory contains samples for python-oracledb, the Python driver for Oracle Database.

The schemas and SQL objects that are referenced in the samples can be created by running the Python script create_schema.py. The script requires SYSDBA privileges and will prompt for these credentials as well as the names of the schemas and edition that will be created, unless a number of environment variables are set as documented in the Python script sample_env.py. Run the script using the following command:
```
python create_schema.py
```
Run a Python script, for example:
```
python query.py
```
After running python-oracledb samples, the schemas and SQL objects can be dropped by running the Python script drop_schema.py. The script requires SYSDBA privileges and will prompt for these credentials as well as the names of the schemas and edition that will be dropped, unless a number of environment variables are set as documented in the Python script sample_env.py. Run the script using the following command:
```
python drop_schema.py
```

About python-oracledb

Python-oracledb is the new name for Oracle's popular Python cx_Oracle driver for Oracle Database.
Python-oracledb 1.0 is a new major release - the successor to cx_Oracle 8.3.
Python-oracledb is simple and small to install — under 15 MB (including Python package dependencies): pip install oracledb
Python-oracledb is now a Thin driver by default - it connects directly to Oracle Database without always needing Oracle Client libraries.
Python-oracledb has comprehensive functionality conforming to the Python Database API v2.0 Specification, with many additions and just a couple of exclusions.
A "Thick" mode can be optionally enabled by an application call. This mode has similar functionality to cx_Oracle and supports Oracle Database features that extend the Python DB API. To use this mode, the widely used and tested Oracle Client libraries such as from Oracle Instant Client must be installed separately.
Python-oracledb runs on many platforms including favorites like Linux, macOS and Windows. It can also be used on platforms where Oracle Client libraries are not available (such as Apple M1, Alpine Linux, or IoT devices), or where the client libraries are not easily installed (such as some cloud environments).